LinkBack URL
About LinkBacks
Hi friends,
I need a formula by which contents of two columns can be compared
A(Index) B(Type) C
Test1 Value True
Test1 Value True
Test1 Percentage False
ColumnC will return False if the same element in ColumnA has different Types in ColumnB.
Hi friends,
I need a formula by which contents of two columns can be compared
A(Index) B(Type) C
Test1 Value True
Test1 Value True
Test1 Percentage False
ColumnC will return False if the same element in ColumnA has different Types in ColumnB.
Last edited by Kuntal; 11-22-2012 at 05:22 AM.
somthing like...
=IF(A2=A1,IF(B2=B1,"True","False"),"True")
Its not working...
Hi, welcome to the forum!
Could you upload a sample sheet so that we may help you better?
Click on Go Advanced below this thread and then on 'Manage Attachments'.
Col D contains the desired results.
no sure how thats not working for you....could you please check the attached sheet
Ur Formula is working only if continuity is maintained. Which is unlikely. Red legends in the excel are the errors.
Hi....got it now
Below might be helpful. Please find attached the revised sheet.
=IF(B2=VLOOKUP(A2,A:B,2,0),"True","False")
Hi Kuntal,
Not sure if this is what you want but give it a try.
In cell E2 and below use the below formula (use this as a helper column):
Formula:
Please Login or Register to view this content.
Then in cell F2 and below:
Formula:Please Login or Register to view this content.
Wherever you get the message "Repeated Entry" it would mean that combination of Index and Value are already appearing somewhere else in the dataset and where it says "Single Entry" those would be unique records.
Does that help?
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
Not working...Originally Posted by kbkumar
Hi Kuntal,
Not sure if this is what you want but give it a try.
In cell E2 and below use the below formula (use this as a helper column):
Formula:Please Login or Register to view this content.
Then in cell F2 and below:
Formula:Please Login or Register to view this content.
Wherever you get the message "Repeated Entry" it would mean that combination of Index and Value are already appearing somewhere else in the dataset and where it says "Single Entry" those would be unique records.
Does that help?
Upload your workbook and state the desired output...
Check the output.
Hi Kuntal,
have you checked the revised formula in my earlier post? This works for all cases in your attachment.
PFA
=IF(B2=VLOOKUP(A2,A:B,2,0),"True","False").
Yes it works.. But can you plz make it work in this sheet.
Also plz explain how it works.
Hi,
Please find attached the updated sheet.
1) VLOOKUP(C4,C:E,3,0): The formula will lookup intex type for each index name. So, for T1 index type would be "Value" and for T2 "Percentage".
2) IF(E4=VLOOKUP(C4,C:E,3,0),"True","False"): This will compare E4 with the value of lookup as above. If it matches, then true else false.
Thnx a lot Sir...
Thanx a lot Sir...
Now I need to see if same Index has been written for the same Date. If in the same date there is more than one Index of same Name the give False. Plz help me out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks