text criteria

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> a 2 g 4 q 6 f 7 a 4 t 6 </tbody> From the data set above I would want to vlookup for "a" and return the value 4 instead of 2. I believe this post is a good starting point...

Based on different text criteria, I am trying to return the Max and Min numbers for each criteria from a separate table Example: Criteria Table: Unit Type Min Rent Max Rent 0 BR ______...

Hello, This has been a problem for me for a while but so far I've managed to deal with it manually. I've a got the following table: <colgroup><col><col></colgroup><tbody> COLUMN A COLUMN B Planned Delivery Date : 01-08-2012 x1 y1 Planned Delivery...

Hi, I have one column with code letters such as T, S, P, O, the other column values. I want to sum the values when a corresponding matching letter is present. =SUMPRODUCT(--(CAT="T"),DV12:DV74) Works, but =SUMPRODUCT(--(CAT="T"),--(CAT="O"),DV12:DV74) does not. I even tried...

Hi all, New to the forum and also Macros. I am trying to write code to make a cell default to a negative value based on the text of another cell. For example: if the cell states "EXPENSE" then the offset(0,1) will be a negative figure when the numbers are entered into that cell. Any help...

I want to use a COUNTIF formula to count how many times cells with a range contain specific words. Each cell will contain four words but I only want to count 2 of them. For example: Cell 6B contains the term BAN10 (one of the words that I want to count), Cell E2 contains the term EB (yet...

I have 2 columns on an expense sheet, 1 for company expenses and 1 for billable expenses then a column with amounts. I want to sum all the values for the company expenses and billable expenses seperately but each item has a different value (ex: parking NYC). How can i do that with sumif or...