# Search:

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

Page 1 of 5 1

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

by Ultimate Selector
Replies
51
Views
1,887

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

Yes Pete! Absolutely perfect!

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

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

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

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

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
51
Views
1,887

### 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!

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

by Ultimate Selector
Replies
51
Views
1,887

### 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