Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or sumproduct formula for 2 columns data validtion
need to flag in 3rd column when data based on 2 other columns is repeated
I have two columns where data needs to be validated based on the two columns. Trying to get the Sumproduct() to do it for me but its not coming back right Column A B Customer group Client Employer Group-National 0001 Key Accounts 0001 Health Plans 0001 Employer Group -Systemed 0001 Other Customer Group 0001 I want to setup a column PC With formula flag to let user know if they are repeating the group/client combination The group should be one of the ones listed and the client can be any client. customer group can repeat only for another client number Can you help me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or sumproduct formula for 2 columns data validtion
Have a look at:
http://www.mvps.org/dmcritchie/excel/duplicates.htm http://www.cpearson.com/excel/duplicat.htm#Replacing -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JC" wrote in message ... need to flag in 3rd column when data based on 2 other columns is repeated I have two columns where data needs to be validated based on the two columns. Trying to get the Sumproduct() to do it for me but its not coming back right Column A B Customer group Client Employer Group-National 0001 Key Accounts 0001 Health Plans 0001 Employer Group -Systemed 0001 Other Customer Group 0001 I want to setup a column PC With formula flag to let user know if they are repeating the group/client combination The group should be one of the ones listed and the client can be any client. customer group can repeat only for another client number Can you help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup occasionally returns formula with no data | Excel Discussion (Misc queries) | |||
Sumproduct - formula to return data OTHER than given criteria | Excel Worksheet Functions | |||
do i use vlookup or sumproduct??? | Excel Discussion (Misc queries) | |||
Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |