| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 3 columns of criteria simultaneously
Hi Sheeloo,
At least the rows in the range need to be absolute to enable the formula to be copied down. =COUNTIF(G$1:G$100,G1) -- Regards, OssieMac "Sheeloo" wrote: One way is to concatenate the values in Column G like this =A1&B1&C1&D1&E1&F1 then use this in Col H =Countif(G1:$G100,G1) (change 100 to the last row number) and copy down. Cells with value 1 will show duplicate cells. "Michael Joseph Cosgriff" wrote: I have used a RANDOM NUMBERS web page to make a collection of 6 columns from A1 to F50. Now I want to scan them to see if I have repeated any rows. Can someone help with a formula Mike Cosgriff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Columns if Criteria Met | Excel Worksheet Functions | |||
| Adding data in columns based on criteria in more than one column.. | Excel Worksheet Functions | |||
| adding data simultaneously onto 3 worksheets | Excel Worksheet Functions | |||
| Delete columns simultaneously in several different workbooks | Excel Discussion (Misc queries) | |||
| In Excel how can I filter multiple columns SIMULTANEOUSLY? | Excel Discussion (Misc queries) | |||
Threaded Mode
