Search:

Type: Posts; User: Ultimate Selector; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Format the 3 numbers in a column closest to ZERO

    Yes Pete! Absolutely perfect!

    Thanks again my Friend! :cool:
  2. Re: Format the 3 numbers in a column closest to ZERO

    Hi Pete,

    Hope all is well ...

    I have one more issue for you to resolve if you could please.

    I am trying to add up the net value of these individual rows.

    Then I want to also add up...
  3. Re: Format the 3 numbers in a column closest to ZERO

    Well once again you earned your keep Pete!
    I was using a whole number of -9 instead of the -0.09 in my CF formula.

    I knew it had to be something simple but I would have never thought it was...
  4. Re: Format the 3 numbers in a column closest to ZERO

    -9%

    All numbers that are -9 and below.
    If there is one then just one. But if there are say 3 that are below -9 or lower then all three of those numbers.
  5. Re: Format the 3 numbers in a column closest to ZERO

    Here is a column of sample data.
    Column V8 to V14 specifically.


    <tbody>
    -12%


    -33%
  6. Re: Format the 3 numbers in a column closest to ZERO

    Yes that is correct ... I am serving another function separate from the other one. I'm still good with that one.
    I want to HL all numbers below -9

    Thanks Pete!
  7. Re: Format the 3 numbers in a column closest to ZERO

    Using a negative number seems to mess it up cuz I have tried several different ways and several different format techniques.
  8. Re: Format the 3 numbers in a column closest to ZERO

    Hi Pete!

    I'm having an issue with the highlighting format of using a Negative number in the formula. This number happens to -9
    ...
  9. Re: Format the 3 numbers in a column closest to ZERO

    Perfect!

    Once again you come thru! Excellent work!

    U R Da Man! Thanks Pete!

    Regards,
    U.S.
  10. Re: Format the 3 numbers in a column closest to ZERO

    Simple thing to do is just rank your example data numbers with the formula I provided.
    Of course change the range to whatever you need to for your own example.
    ...
  11. Re: Format the 3 numbers in a column closest to ZERO

    Sorry my bad, it's late and I've been at it all day. I don't know how that happened.

    Here is the correct numerical rankings from your example data.


    11.4 = Rank #8
    9.7 = Rank #6
    5.2...
  12. Re: Format the 3 numbers in a column closest to ZERO

    so I can rank them in table 1 by using this formula. The result is table 2 ....
    Of course change the range to whatever you need to for your own example.
    ...
  13. Re: Format the 3 numbers in a column closest to ZERO

    Let's use your example. Column one I already have done and completed. No problems there.

    Column two is the column that will rank column one numerically. 1-2-3-4-5-6-7-8-9-10

    I will show you...
  14. Re: Format the 3 numbers in a column closest to ZERO

    Hey Pete,

    By the way ... wanted to let you know that I am using that formula from post 11 in a column.

    Now what I want to do is rank that column with the numerical (1,2,3) ranking system I...
  15. Re: Format the 3 numbers in a column closest to ZERO

    Because I want to rank them with a number system of 1-2-3 etc. in a different column.

    Lowest being number 1 and so on.
  16. Re: Format the 3 numbers in a column closest to ZERO

    Again, Thanks sooo much Pete! :cool:
  17. Re: Format the 3 numbers in a column closest to ZERO

    Here is the data I'm ranking closest to zero if you would like to use this for your reply.


    <colgroup><col style="mso-width-source:userset;mso-width-alt:1582;width:34pt" width="45"> ...
  18. Re: Format the 3 numbers in a column closest to ZERO

    This is what happens when I have no data in the cells because I have no entries.
    I may have only 8 entries or maybe just 6 or even 10.
    But this is what happens on the formatting. It wants to...
  19. Re: Format the 3 numbers in a column closest to ZERO

    Hey Pete,

    This formula ranks the closest to zero as well.
    It is being used in conditional formatting.
    The formula is being applied to all entries in the column.

    4) Yes, same exact issue when...
  20. Re: Format the 3 numbers in a column closest to ZERO

    Hey Pete back again ....

    I have the same issue with this formula when I delete an entry.
    It just keeps the remaining higher numbers of ranking because of the deletes. It assumes the celss I...
  21. Re: Format the 3 numbers in a column closest to ZERO

    Thanks Pete! Once again you're spot on.

    I don't know what I did earlier but it works great now!

    Much Appreciated!
  22. Re: Format the 3 numbers in a column closest to ZERO

    Sorry Pete but I did it several times and I get the "error message" popping up!

    Another idea or thought?

    Thanks!
  23. Re: Format the 3 numbers in a column closest to ZERO

    I see that Pete Thanks my friend.

    I have one other question for you.

    If I wanted to change the number from closest to zero and lets say make it closest to 50 instead where in the statement...
  24. Re: Format the 3 numbers in a column closest to ZERO

    Hello Aryatect,

    Thanks for correcting my statement. I did use the 4 in the same function which was max.
    I didn't move to the next argument. My bad!

    Much Appreciated on your input!

    Have a...
  25. Re: Format the 3 numbers in a column closest to ZERO

    Most excellent Pete! Absolutely Fantastic!

    My bad when I said deleting columns when indeed I meant rows!
    This has been kickin my Azz for over a year now!

    Works like a charm! You're a genius!...
Results 1 to 25 of 108
Page 1 of 5 1 2 3 4