Excel Help Needed

Reply #2

Rakster — Sun, 21 Oct 2007 17:01:15 GMT

Thanks Phil for the response, it helped me big time

Reply #1

phileight — Sat, 20 Oct 2007 21:58:39 GMT

Rakster

I may be missing something in what you want. the countif function will do what you want. The firefox browser I use won't let me copy and paste. set up a column whereever enter the values 0-9. this is your reference number. then use the countif function, point to your data range, and count if it matches you reference number. once you have 1 value working copy and paste for the others. make your reference number a fixed reference.

p8

Excel Help Needed

Rakster — Sat, 20 Oct 2007 19:42:31 GMT

Is there a way to inpliment a formula where it would recognize a zero value and assign its numeric value to it?

Heres an example of what I am trying to find...

#'sD1D2D3

1111

2102

3000

4200

5010

6102

7010

8131

9001

0110

For the number 9 we have ZERO in the first column and ZERO in the second column... is there a way that in another area of the spreadsheet, that I can have it recognize this zero in the NINE spot and therefore re... [ More ]