Hi
A formula approach and format cells as "hh:mm AM/PM"
=--MID(E2,FIND(":",E2)-2,8)
Type: Posts; User: Kevin@Radstock
Hi
A formula approach and format cells as "hh:mm AM/PM"
=--MID(E2,FIND(":",E2)-2,8)
HI
Maybe try incorporating the LOOKUP function.
=LOOKUP(MONTH(A1+180),{1,2,3,4,5,6,7,8,9,10,11,12},{"JA","FE","MR","AL","MA","JN","JL","AU","SE","OC","NO","DE"})
Alternatively the VLOOKUP can...
Post a sample not the whole book!
Hi rich_cirillo
The COUNTA returns the returns the number of cells that are not empty. Then returning that to the OFFSET function for the Height.
See the link on the OFFSET function.
Kevin
Hi rich_cirillo
You could use data validation. Create a list in your sheet say in column V, in V1 & copy down:
=TODAY()+21*ROW()-21
Data Validation:
=OFFSET($V$1,0,0,COUNTA($V:$V),1)
Hi Stalker
The INDEX & MATCH will achieve this for you.
=INDEX($B$3:$I$3,MATCH(LARGE(B3:I3,1),B3:I3,0)-1)
Hi leopaulc
The first thing is to convert all the text numbers to real numbers. Select a blank cell, copy > Select the data C2:AD27 > Paste Special > Tick the Add > Click OK > format cells as...
Hi Orestees
May be using the IF & LOOKUP, see the attached file. You need to stay clear of merging cells, they are the work of the devil!
Hi Ryan_Bernal
Another solution for the formatting might be.
Rule 1 Green: =COLUMNS($E$3:E3)<=$B$3
Rule 2 Red: =AND(E$3<>"",COLUMNS($E$3:E3)>$B$3)
Kevin
Hi
Or another version:
=SUMIF(C5:C15,J20,D5:D15)+SUMIF(C5:C15,J21,D5:D15)
Kevin
Hi mag
Not quite sure what you mean. See the attached, is this what you mean or something along those lines!
Kevin
Hi mag
See the attached file.
Hi Excel Fox
Thank you for that.
Hi with reference to this post http://www.excelfox.com/forum/f2/less-than-greater-than-equal-concatenate-cell-value-form-if-formula-714/. Regarding the smiley's.
I would also like to know how to...
Hi Howardc
Could you not record a macro for something like that.
Kevin
Hi
My first post!
Another version for a formula approach in B2:
=SUM(OFFSET($B2,0,1,1,LOOKUP(2,1/$C2:$T2,$C2:$T2))) and copy down.
Also accounts for cells not filled in continuously.