Welcome Guest
Log In | Register )
You last visited December 7, 2016, 5:07 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Help Needed

Topic closed. 2 replies. Last post 9 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: October 20, 2007, 3:42 pm - IP Logged

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 record it as such.  So when I inpliment past data, it would recognize that there were no 9's called in the first column and tells me 9's -- zero in first column and so on for other numbers?

I know it sounds confusing but i am hoping someone can help answer this.

Thank you.

We are all Lucky... just some of us don't realize it!

    Avatar

    United States
    Member #41846
    June 23, 2006
    459 Posts
    Offline
    Posted: October 20, 2007, 5:58 pm - IP Logged

    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 

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: October 21, 2007, 1:01 pm - IP Logged

      Thanks Phil for the response, it helped me big time!

      We are all Lucky... just some of us don't realize it!