Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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!
  2. 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!
  3. 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...
  4. 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...
  5. 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!...
  6. Re: Format the 3 numbers in a column closest to ZERO

    I now understand that this means small and max.
  7. 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...
  8. 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)
  9. 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...
  10. 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...
  11. 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:
  12. 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...
  13. 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...
  14. Re: Conditional Format If this happens!

    The conditional format formula will also NOT copy down the row. It keeps just that first cells formula all the way down!
  15. Re: Conditional Format If this happens!

    Thanks Aryatect! great examples pics! works fantastic ... however, the only issue is that it will highlight just a single cell of the three cells. I need it to highlight all three cells ONLY if...
  16. Conditional Format If this happens!

    Let's say I have 3 columns with 3 numbers in them.

    Example ... Columns R-S-T ... In these cells are the following numbers.

    9-12-19

    Now what I want to do is highlight the whole row of...
  17. Re: Is there an easier way to copy and paste without using macros or vba?

    So do I need to have the formula when I paste it? Cuz when I special paste it I check the box to have all formulas and whatnot copied with it as well.

    Why doesn't it just paste the data that is in...
  18. Re: Is there an easier way to copy and paste without using macros or vba?

    Is it because all of my calculations to get the answers for those cells in the pasted post are in the first book?
  19. Re: Is there an easier way to copy and paste without using macros or vba?

    Here is exactly what happens ... First row is actual copy of data.


    The second row is after I paste it to another book.



    <colgroup><col...
  20. Re: Is there an easier way to copy and paste without using macros or vba?

    The formatting isn't the problem. It's the actual data in each of the cells. For some reason the data isn't being transferred. I don't know why.
  21. Re: Is there an easier way to copy and paste without using macros or vba?

    Thanks MB for your response. I have tried to do it manually with paste special and all. However, it still does not paste the same data. I would then have to go and re input all the lines of data and...
  22. Re: Is there an easier way to copy and paste without using macros or vba?

    I am Bumping this simply because I still have not found an answer in all my research for this problem.

    I hope there is someone here that can help me out on this issue!

    Much Appreciated!
    U.S.
  23. Re: Is there an easier way to copy and paste without using macros or vba?

    What more would like for me to explain to help you understand my dilemma?
    All I want to do is to simply take one simple line of data among other lines of data from one workbook let's call it Book...
  24. Re: Is there an easier way to copy and paste without using macros or vba?

    Well I guess by all the replies this thread has recieved it must mean mean that there is no way to accopmlish this! LOL!
  25. Is there an easier way to copy and paste without using macros or vba?

    Just curious if there is a simple and easy way to copy and paste one line of data from one workbook to another and have it retain it's values and conditional formatting? It simply needs to look...
Results 1 to 25 of 88
Page 1 of 4 1 2 3 4