# Search:

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

Page 1 of 4 1

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

by Ultimate Selector
Replies
38
Views
748

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

I now understand that this means small and max.
19. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

By the way Pete,

Jut wanted to let you know I am highlighting the closest thee to zero by using a different color for each by changing the last number in the formula from 3 then to 2 then 1 each...
20. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

What do these two numers represent in the formula?
The 15,4

=ABS(A2)<=AGGREGATE(15,4,ABS(A\$2:A\$10),3)
21. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

It is a single column just as I posted. However, it can go up to and including 14 entries.
The one I posted has 10 entries. Now use the formula and then go delete a row or two say A2 and A9 in...
22. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

Hey Pete ...

It works fine if yur in a static mode and don't delete any columns. So if I start with 10 and don't delete any it's ok on both formulas.
However when I delete columns say 3 of the...
23. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

Booo Yaaa!!! Thanks sooo much Pete! This was exactly what I needed. I have been searchin for this forever!

U Da Man! Have a spectacular Morning!

Regards,
U.S. :cool:
24. ## Thread: Format the 3 numbers in a column closest to ZERO

by Ultimate Selector
Replies
38
Views
748

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

Ok so here is what I'm trying to do. Here are my numbers ..
I want to highlight the three lowse numbers closest to zero. Which would be numbers
0.1 , -.08 and 0.9 ...
I have tried several...
25. ## Thread: Conditional Format If this happens!

by Ultimate Selector
Replies
7
Views
161

### Re: Conditional Format If this happens!

I got it figured out guys! Here is the other step that needs to be included in the formula.

=AND(\$Q6<\$R6,\$Q6<\$S6,\$R6<\$S6)

It seems you can't formula copy all the rows at one time.
I did...
Results 1 to 25 of 100
Page 1 of 4 1