I want to have my data in descending order to determing the top without using the descending button because I will be using this to a database. My data includes zeros and most of the numbers has the same number
I want to have my data in descending order to determing the top without using the descending button because I will be using this to a database. My data includes zeros and most of the numbers has the same number
In F3 and copy down
Formula:
Please Login or Register to view this content.
In E3 and copy down this ARRAY formula.
Formula:
Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Did you confirmed the formula as an ARRAY?
See post#4!
Thanks, that solved the problem. I am not familiar with the confirm array but now I know (almost :-) ... Is there a shortcut to do cntrl+shift+enter? Because I have thousand of rows and columns. I tried to highlight entire row and do cntrl+shift+enter and it didnt work
QUOTE=Fotis1991;3680435]See post#4![/QUOTE]
Glad that works for you.
As i know there is not a shortcut for this.
But here is how to use these formulas.
Let,s say that you type the formula in a cell. Go to Formula bar>click there and pres the three keys(Ctr+Shift+Enter). Then just drag down or right them.
From the link that i provided thai i suggest to take a look.
..ENTERING AN ARRAY FORMULA: To enter a formula as an array formula, type the formula in the cell and press the CTRL SHIFT and ENTER keys at the same time rather then just ENTER. You must do this the first time you enter the formula and whenever you edit the formula later. If you do this properly, Excel will display the formula enclosed in curly braces { }. You do not type in the braces -- Excel will display them automatically. If you neglect to enter the formula with CTRL SHIFT ENTER, the formula may return a #VALUE error or return an incorrect result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks