## Counting Cells with Text under a certain number

Hello, I need to create a formula that will count the number of cells that contain the number 12 or lower. However, the cells are not just numbers but text as …

Hello, I need to create a formula that will count the number of cells that contain the number 12 or lower. However, the cells are not just numbers but text as …

Hello, I’m not sure how to ask this question in a concise way. I have a very large table of ecology data. One column is the “Species”, the …

Hi there, I have a list of 35k contacts, I need to sort unique after unique. I sorted them by “Domain” column, now I need to sort 1st unique …

Hi I am trying to create a relatively complex IF function in Excel but with no success. I have the boundries: (M8<=0.075) and (N8 is between -0.005 …

Hi i have a sheet with column Total Expreience and all these numbers are as follows. 11.03, 0.1,0.11,10.00 and so on…. So my boss wants to know the count …

In showrooms we have price stand. I have entered all the price, price details in excel. Price Stand size is : 15 cm x 21.5 cm and in printer i have A4 SIZE …

Hello all, I need help using excel formulas to figure out the date and time of deadlines. I don’t need a timer since the spreasheet will only be to see …

Sir, I want to increse the number by 1 in a cell with time interval of 30 secods, so it is possible? Just like in cell A1 there is number 1 and it should be 2 …

I have 36 months of data and am trying to calculate YTD YOY results. I know =((x-y)/y)*100 will get me a YOY percentage change comparing two months in …

Hi everyone, I’ve been scouring the internet for a solution to this but can’t find exactly what I’m looking for. I have gathered …

Hi, I have a master worksheet with a column of cells all containing hyperlinks to website. I need to update these yearly (because they change). In other …

Hi Everyone I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this …

Hello, I’m hoping someone will be able to help – I have been trying to come up with a way to do this but haven’t been able to so far and so I …

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

Need formula – Column1 Column2 Column3 Column4 Column4 Day 1 Staff Day 2 …

Hello, I have a column like 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 5.01.2016 …

I have been asked to try and save a member of staff half an hour a day, but creating a rota, which is automatic. I didn’t think that it was possible but …

I need some help with creating an excel formula. On sheet one, i want to add a value ($100) on cell D5 and a date on cell E5. Then, sheet two has all the …

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

Hi everyone, Could someone please help me with the below VBA code. Instead of displaying the results in different rows of the same cell, I want to …

I am trying to populate the PRICE column by using a KEY with prices in it to match up to the PLAN codes. What formula do I use? KEY 1224A …

i want to make a simple menu where one can choose from a list in cell, between the numbers from 1 to 5 I just need the formula which i must type on a cell or …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

My data (test scores) are located in varied cells according to the year when the test was taken, like this: …

Hi…I was wondering if someone can help me out. It would be very much appreciated. I want to create an excell sheeet with some drop downs and add a …

Is there any way to take this formula or a variation of this formula and have it drag and change the months so that my formula stays the same but the months …

Hi, So my question is say if I can set a control in sheet 1 to define date May 4th and May 5th as week 1. May 8-12 as Week 2 and so forth. I want that as …

hi, i am unable to build farmula in some situation, when i use vlookup function it always pick 1 value how do i get rid of this problem. …

Hi, I’m a triathlete, and I’m trying to create my own training log. I’m stuck on one cell. I need a formula to calculate my swim pace per 100 …

Excel 2013 not shown so please note I use 2013 The number in question is 600,000 the %’s are as shown. Assuming each % of the number is correct …

This code is used to rearrange scattered data in many tables. In the line having comment, the run time error rejects extracting the row of loop variable D, …

Item Profit Basketball $ 10.00 DVD $ 12.00 Football $ 10.00 …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

I have a spreadsheet containing many thousands of rows extracted from a document management database. Each row has multiple columns. Across those colimns …

Can you please help me for a formula in this example… in the Final Code, i want an answer in A2 If B2 has an answer, then A2 is = to B2 if B2 has …

In excel solver,i need a variable to either be zero or lie between 50% of max to 100%. i.e it should not lie between 0 to 50% but can be zero. how to add a …

I have a problem I am trying to solve. I have a list of names in one column and the corresponding emails addresses in another column saved to a workbook …

Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …

I would like a macro that does the following: It would look in a specific row and find the cell with the largest number in this row, and then inserts a …

/* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.