Posted to microsoft.public.excel.worksheet.functions

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Selective cell changes

HI

In column Y I have a row of numbers.

I need to change them so that the cells which are 0 stay the same , and
cells with numbers greater than 0 in them are replaced with the word
'Active' .

Can someone help with this?

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
Selective concatenation using VBA	Colin Hayes	Excel Worksheet Functions	3	April 17th 07 02:47 PM
Selective addition	Peter	Excel Worksheet Functions	2	March 12th 07 10:33 AM
Selective calculation	PH NEWS	Excel Worksheet Functions	2	September 21st 06 01:33 PM
selective autofill with functions	vicvega	Excel Worksheet Functions	3	February 14th 06 03:19 PM
selective averaging	Wazooli	Excel Worksheet Functions	3	December 10th 04 09:25 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us