Posted to microsoft.public.excel.programming

WYMMIY

external usenet poster

Posts: 5

Formula or code?

I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
Col1 Col2 Col3
Row 1 EC QWERTY POIUY
Row 2 (EC-x) ZXCVB QWERTY
RO3 EC lkjhg ZXCVB
.....
Row 4 (EC-x) rtyui QWERTY
Ro4 (EC-X) asdfg lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.

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
formula in code	geebee	Excel Programming	2	May 21st 08 04:15 PM
Formula in code	jln via OfficeKB.com	Excel Programming	2	July 13th 07 03:02 PM
formula or code?	Curt	Excel Programming	5	April 8th 07 05:16 AM
formula or vba code	Nader	Excel Programming	3	August 15th 06 03:11 PM
Help with code or formula	Gareth[_3_]	Excel Programming	8	October 18th 03 12:43 AM

All times are GMT +1. The time now is 06:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us