Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1,397

No place for sum

select row 7 and below.
data sort by column B

" wrote:

Hi
Sorry. One more question.
How can I sort my list according to B column ? It is date.
(I mean with formula change)

On A7

=IF(sheet1!B2="nameA",ROW()-5,"")

On B7 and others

=IF(ROW(A1)COUNT($A:$A),"",INDEX(sheet1!A:A,SMALL ($A:$A,ROW(A1))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up function best place	pianolady	Excel Worksheet Functions	1	October 22nd 06 12:45 AM
Nil in Place Off #N/A	Steved	Excel Worksheet Functions	2	April 6th 06 02:41 AM
This place ROX!!	brodiemac	Excel Discussion (Misc queries)	0	December 22nd 05 03:21 PM
1st, 2nd, 3rd Place etc.....	JohnT	Excel Worksheet Functions	7	January 9th 05 12:41 PM
Where to place PERSONAL.XLS	PCOR	Excel Worksheet Functions	1	January 2nd 05 11:19 PM

All times are GMT +1. The time now is 01:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us