Copying cells based on a criterion

Posted to microsoft.public.excel.misc

Chris_t_2k5

Posts: n/a

Copying cells based on a criterion

Here is my problem.

I have cells A1:a100 full of numbers.

I wish to select all numbers that are lower than 20 for example and paste
them into cel B1 and down.

I know i could copy and paste but I need more complicated calculations than
that.

THEREFORE is it possible to copy cells based on af statements etc??

Thanks

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
checking that cells have a value before the workbook will close	kcdonaldson	Excel Worksheet Functions	8	December 5th 05 04:57 PM
adding color to cells based on a formula	fyrfytr265	Excel Worksheet Functions	2	November 1st 05 05:17 PM
Creating a conditional format for a cell based on another cell's v	steve-o	Excel Discussion (Misc queries)	2	October 26th 05 03:51 PM
zero value when copying cells between worksheets	joe	Excel Discussion (Misc queries)	1	August 9th 05 08:51 PM
Add cells from a range based on 2 conditions from 2 other ranges	Kelly	Excel Worksheet Functions	3	July 7th 05 07:40 PM

All times are GMT +1. The time now is 10:41 PM.

Menu

About Us