# Archive by month May

## 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 …

## PhD Researcher

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 …

## IT

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 …

## Help with complex “if” function

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 …

## Need help to create a chart with bins

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 …

## Set Paper as per Paper stand

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 …

## Calculate hours and date for deadline

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 …

## Increment the numbers in cell with time interval automatically

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 …

## easy one but how?

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 …

## Comparing each month’s daily sales with multiple years as columns

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 …

## Challenging Question bugging me to death

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 …

## Conditional Formatting Help

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 …

## Vlookup or if

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

## Quality Data Analyst

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

## date format

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 …

## Stuck at work!

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 …

## Excel Formula to copy value and date to another cell based on date range

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 …

## How to sum multiple rows and columns

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 …

## Multiple items dropdown formatting

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 …

## Match

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 …

## choose from a list in cell

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 …

## If/Vlookup Help?

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 …

## Moving data new column

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

## Drop down and value

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 …

## Birdcelts

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 …

## IF Functions

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 …

## unable to build farmula

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

## Swim Pace Formula

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 …

## % of a number

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 …

## Why I get Object Required Error message in the line with comment?

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, …

## Averages for groups separated by rows?

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

## Sum letter and his value

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 …

## VBA to identify and eliminate duplicate cells

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

## if Formula

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 …

## impose two condtiions on variable in excel

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 …

## Transferring data from one worksheet to multiple spreadsheets in another workbook

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 …

## Sorting Extensive Dates and Times

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 …

## macro insert column

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 …

## Index Match Match with Two If Statements

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