I have a formula to get unique values from a column....Can anyone help me to re write with the funcations in attached file...
Formula...
=IF(ROW()-3>$B$22,"",VLOOKUP(ROW()-3,$B$4:$C$22,2,FALSE))
Macro is not allowed...
Appreciate any help.
I have a formula to get unique values from a column....Can anyone help me to re write with the funcations in attached file...
Formula...
=IF(ROW()-3>$B$22,"",VLOOKUP(ROW()-3,$B$4:$C$22,2,FALSE))
Macro is not allowed...
Appreciate any help.
Last edited by NBVC; 04-16-2009 at 07:35 AM.
It would be good to see the data you are trying to apply the formula to also and how the current formula works with it.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
File attached...My_Excel_Issue.xls
Please find the formula in "KM_Data_Model" sheet . Formula works fine in current sheet with Row()...but it need to be replaced with something else to make it work in my application.
How about?
copied down=IF(COUNTA($D$4:$D4)>KM_CS_Raw_data!$X$219,"",VLOOKUP(COUNTA($D$4:$D4),KM_CS_Raw_data!$X$4:KM_CS_Raw_data!$Y$219,2,FALSE))
It worked well for other columns...but unable to get for column "D"..got circular ref related error...
I modified the format bit now to separate year and month values...Can you please help me to get the unique data in "model" sheet..
Thanks a lot.
attached update file...
A little confused about what ultimately you want...
I put this formula in H4, copied down
and the same formula in J2, but only changing the 2 in the Vlookup to 8 so that it looks at the correct column.=IF(COUNTA($F$4:$F4)>KM_CS_Raw_data!$X$219,"",VLOOKUP(COUNTA($F$4:$F4),KM_CS_Raw_data!$X$4:$AE$219,2,FALSE))
Is that right or wrong?
Did your ROW() formula work for your newly laid out data?
If wrong, post the workbook showing expected results and why...
This has gotten more complex than the original question asked.
Why don't you split the data up in the Raw data sheet to make 2 separate columns for year and month and then use the same logic as before?
Thanks for all your help. I will split in raw data sheet to finish my task....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks