Thanks: 0
Likes: 0
Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 6 of 6
Thread: Tankstand needs Excel help
-
2nd October 2008, 08:22 PM #1
Tankstand needs Excel help
Hello Everyone,
I have need of your collective talents.
I have attached an example of what I am trying to do, which is basically asking for the higher of two cells values to show in another cell and the lower in the other. Hopefully the text in my spreadsheet clarifies things.
I am running Office 2007 and the default format of *.xlsx is not able to be uploaded here! I had to save as *.xls!
Thanks,
Mark.The secret to creativity is knowing how to hide your sources.
Albert Einstein
-
2nd October 2008, 08:54 PM #2
G'day Mark,
I've tried a few times, and can't open your attachment.
I'll close down then try again.
Restarted & got the attachment..the logic seems feasible to me......but then again....
I'll not comment further until someone cleverer than I, solves your task.
-
2nd October 2008, 09:33 PM #3
Mark,
Been a while but think this should do for a solution.Last edited by KevM; 2nd October 2008 at 09:33 PM. Reason: wish I could spell
Kev
-
2nd October 2008, 10:09 PM #4More Firewood
- Join Date
- May 2008
- Location
- Laguna
- Age
- 69
- Posts
- 35
Excel Help
Hi
An easier way is to put a formula like:
=MAX(L7, L8)
in the cell where you want the maximum
=Min(L7, L8)
in the cell where you want the minimum
Andrew
-
2nd October 2008, 10:46 PM #5SENIOR MEMBER
- Join Date
- Sep 2007
- Location
- Melbourne
- Posts
- 0
Andrew has got it right!!!!!
Chipman
-
3rd October 2008, 12:21 PM #6
A Huge thankyou to Kev and Andrew!
Both ways work,
I nearly got there with the "IF" method.
I love this forum!The secret to creativity is knowing how to hide your sources.
Albert Einstein