text values

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...

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...

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 :(

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...

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...

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...

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...

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...

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...

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...

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...