by sysp34 » Sun Jan 13, 2008 7:27 pm
[quote=Red Devil:1200098554]
Sorry forgot to attach file
Can anybody help me with a function in Excel, I am having problems with the Match function.
See attached part of a spreadsheet I use with the segment filter, I am trying to use the Match filter in TAB Segment1, in the cells highlighted in "Lilac".
The 1st line works OK (Z32 & AA32) however, when I copy down matches are missed, eg, AA33 misses the fact that V3 should return a value of "1", AA34 misses a return value of "2".
Can anybody see what I am doing wrong,? :wand: :wand:
Red devil
[/quote]
hello RD
it seem the problem on col. V i assume you input manually or copy and paste in value format
and on cell z32:z38 you input a number format as a result you will get a "wrong" skip numbers
Rpt
0 29
1 16
2 15
3 19
4 17
5 20
6 106
change value in cell z32:z38 with text format (right click - format cell -> text) and you get this result
Rpt
0 #N/A
1 2
2 1
3 7
4 3
5 4
6 #N/A
is it what you're looking for? also if you want to see 0 value which is lastest skip change formula =MATCH(Z32,V:V,0)-1 with =MATCH(Z32,V:V,0)-2 the result become like this
Rpt
0 #N/A
1 1
2 0
3 6
4 2
5 3
6 #N/A