| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare cell values in row for matches - support needed
Hi,
I please need some support for to program the following macro: the value of column Z in a row should be compared with the values in columns N to S in the same row (values in comparison are dates). The output of the comparison should be input in column T of the same row. If no matching values (dates) are found the output value = 0, match value = 1. Please let me know when this description needs to be refined. I greatly appreciate any support! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare cell values in row for matches - support needed
=if(countif(n1:s1,z1)0,1,0)
or --(countif(n1:s1,z1)0) Hannes wrote: Hi, I please need some support for to program the following macro: the value of column Z in a row should be compared with the values in columns N to S in the same row (values in comparison are dates). The output of the comparison should be input in column T of the same row. If no matching values (dates) are found the output value = 0, match value = 1. Please let me know when this description needs to be refined. I greatly appreciate any support! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| excel sum values if cell matches a value | Excel Worksheet Functions | |||
| If a cell matches a list of values...... | Excel Discussion (Misc queries) | |||
| formula support needed | Excel Discussion (Misc queries) | |||
| support needed on .CSV file | Excel Programming | |||
Linear Mode
