Hi,
I have a spreadsheet which I need some help!
I need the Result page to show only the filled one in 2013 column and the date according to the year, is this possible?
Thanks
Y
Hi,
I have a spreadsheet which I need some help!
I need the Result page to show only the filled one in 2013 column and the date according to the year, is this possible?
Thanks
Y
You will get the answer in seconds if you show the expected output also..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixsense,
Thank you
for example:
I wanted the result page to result all the name thats have 2013 awards
for example: name 1, 5, 24/01/2013
Please show the 3 to 4 results in excel for getting better understanding of the expected data structure... :confused;
please find attached updated spreadsheet thanks
any luck yet Sixsense? appreciated of your help!
In B12 Cell of Result Sheet
=IFERROR(INDEX(Data!$A$3:$A$13,SMALL(IF(Data!$F$3:$F$14<>"",ROW(Data!$F$3:$F$14)-ROW(Data!$F$3)+1),ROW($A1))),"")
In C12 Cell of Result Sheet
=IFERROR(INDEX(Data!$F$3:$F$13,SMALL(IF(Data!$F$3:$F$14<>"",ROW(Data!$F$3:$F$14)-ROW(Data!$F$3)+1),ROW($A1))),"")
In D12 Cell of Result Sheet
=IFERROR(INDEX(Data!$B$3:$B$13,SMALL(IF(Data!$F$3:$F$14<>"",ROW(Data!$F$3:$F$14)-ROW(Data!$F$3)+1),ROW($A1))),"")
Drag the formula's Down...
Hi thanks Sixthsense, I have dragged the formula's down but no result :-( can you help? thanks
Oops.. forgot to mention that all the suggested formula's are ARRAY FORMULA's Array Formula - Requires CTRL+SHIFT+ENTER
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
thanks, but the result for the date, is not all correct, I only wanted the one reflects in 2013. is this possible?
Even I can't understand from where you are showing all those dates in 2013
thanks Sixsense, I will use the first 2. appreciated your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks