LinkBack URL
About LinkBacks
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
Please Login or Register to view this content.
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.Please Login or Register to view this content.
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...
Thanks for your help so far...
Please find the attached files
My_Excel_With_ROW_Function.xls : This is my original file with ROW() in Model sheet...
My_Excel_With_Expected_WithOut_ROW.xls : Expected file without Row() or any other funcation which is not in the list provided earlier...In this file I want year and month in separate columns ( In Model Sheet) which I was not able to do...
Appreciate your support...
This formula in H4:
this formula in J4:Please Login or Register to view this content.
both copied down as far as you want.Please Login or Register to view this content.
I made small change (added separate column ..) to the file and it's working fine with your formula.... (It took more time to me to understand what you were doing)
How can I Get the value "2007","2008" and "2009" into KM_Data_Model-Period_YY and months into KM_Data_Model - Period_MM.
I have a Flag Column in KM_CS_Raw_data which will tell if it's a year or month....
So Finally I need something like...
Period_YY Period_MM
2007 200809
2008 ...
2009 ....
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)
Posting Permissions
Register To Reply
Bookmarks