# text values

1. ### If Formula with text and numbers

Hi there, I'm trying to write code for backtesting of trading strategy. Given: Active Worksheet with: Range C2:C200 with range of Text values: Buy, Sell or empty cell Range B2:B200 with Closing Price Lets assume B2= 7.30 is a price per share Reference Worksheet ("Control") with...
2. ### Formulas Based on Differences between months, as text?

Hey so I cannot find the solution nor figure this out for some frustrating reason.. I have two columns that are Months. They have the month names spelled out fully. One is the original, the next is the adjusted. I want to say if the first month is later than the second, "Pulled In" if the...
3. ### Is there a text value among number values?

Hello! Please, how to check a array of cells to find is there a text value? {=SUMPRODUCT(ISNUMBER(Sheet1!A1:D10)+ISNUMBER(Sheet2!A1:F20))>0} This formula isn't working :(
4. ### Combining Range of Text Values Based

Hello, I am having an issue with text and a lack of VBA knowledge. For some reason the "my computer" window won't load (I'm not computer savvy at all)so I can't access my screen shot which I am very sorry about, but here is the issue: I am organizing the number of chemicals found at a particular...
5. ### Conditional Formatting for text matches in ranges

Hi, this has me completely stumped :(:(:( I have a number of text values in range \$H\$5:\$H\$44 I have a block of cells elsewhere (!\$O\$4:\$V\$4) and want any of the values in range 1 to have red text if they match any of the values in this range. Seems very simple and I have tried a bunch of...
6. ### Converting Text Values To Values

Hello guys & gals Below is an example of the report I have generated by our biometric system: Excel 2010 <tbody> A B C D E 5 Dept Manager: MY Total Number of Log: 58 6 Name of Employee Log - In Log - Out Total Hrs 7 xxx 9/1/2013 2:53:44 PM 9/2/2013 12:04:41 AM 9.18...
7. ### Stacked bar chart/normal bar chart with text values

My company gets leads from its website. We give leads different Lead sources depending on where someone came from. Some come from adverts (PPC), others from search engines (Organic search) and so on. We give leads different Lead values, depending on what someone was interested in. So for...
8. ### Excel 2010 Filter doesnt show any text values to allow further filtering

I have an odd problem on a tracker spreadsheet i use. All the columns have a filter, but when you click on the filter arrow it doesnt show you a breakdown of all the text values for that column. All it shows is the usual 'sort A to Z/Z to A', but the bottom half of the pop-up screen is blank...
9. ### Mode type function for text array

Hi. I know there are many many similar threads to this, but I can't get any of them to work for me. I don't know a lot about VBA which is a shame. I'm trying to get to grips with it, because I'm certain it'll make my life easier. In the meantime, maybe one (or more) of you guys can. I basically...
10. ### COunt Unique Text Values Across Multiple Worksheets

I want to count the number of unique text values that appear in the same column but over four separate worksheets.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> So far I have found the following formula which works for a single worksheet but...
11. ### Count unique text values based on condition in another column

Hello, I need to count uniques text values in a column that contains names. But I only need to count the unique values that are satisfying a condition in another column. Example: <TABLE style="WIDTH: 166pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=222...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back