Posted to microsoft.public.excel.worksheet.functions

PJ Murph[_2_] PJ Murph[_2_] is offline

external usenet poster

Posts: 19

Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP

There are single digits in Col A (0-9). I want to know how many times the
double digit numbers in Col B end in the number from Col A. (e.g. if Col
A=1then if Col B=11, 21, 31 etc a counter would increment.)

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
Countif left and alphanumberical data	Onyx	Excel Worksheet Functions	4	June 8th 09 12:27 PM
'RIGHT', 'LEFT' in a VLOOKUP	RJB	Excel Discussion (Misc queries)	6	March 14th 08 12:05 PM
Using LEFT() in COUNTIF	Joe M.	Excel Discussion (Misc queries)	2	January 31st 08 04:12 PM
Vlookup from left to right.	Gareth - Network analyst.	Excel Worksheet Functions	3	February 7th 07 10:45 PM
Vlookup to the left	comparini3000	Excel Worksheet Functions	4	June 23rd 06 09:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us