Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Second last number in list
Steve asked previously
How to find the last number on a list that varies in size: The solution he was given was =LOOKUP(99^99,A:A) Which works perfectly. Now.... is it possible to find the second last number? Thanks in advance, Teddy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying all numbers as positive
Try using a custom number format:
Select the cells to be impacted. From the Excel main menu: <format<cells<number tab Category: Custom Type: #,##0;#,##0;#,##0 Note that format contains 3 sections: postive display, negative display, zero display Experiment with other options if you need to. Also, look up "number format" in Excel help for other options. Does that help? *********** Regards, Ron XL2002, WinXP "TeddyTash" wrote: Ok hope you guys can help: A1= x A2= y A3= A1-A2 If the answer is a positive number I want it to remain as a positive number -but- If the answer is a negative number, I wish for it to be displayed without the "-" sign before the number so it looks like it's a positive number. But I also want it to hold it's negative value so that it can be used later on. Example: A1= 5 A2= 8 A3= A1-A2 A3 Normally displays "-3", I want it to display "3". But I also need it so that if I make A4=A3, then A4 will display "-3" Hope this makes sense to someone! Thanks in advance, Teddy -- TeddyTash |
#3
|
|||
|
|||
Thank you Ron,
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
Select every 10th number in a list | Excel Discussion (Misc queries) | |||
Lookup in a list of number with a headline | Excel Discussion (Misc queries) | |||
Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
How to find the second most frequent number in a list? | Excel Worksheet Functions |