# Archive by month February

## Holiday lookup!

I have a spreadsheet (inherited) that displays the booked holiday for over 70 staff. The spreadsheet is structured with a list employees names in column A (1 …

## 3 condition lookup (or index&match)

Hi, can someone help me with this problem i have. On a source table i have something like this:   m1 m2 m3 a 31-Dec 39 75 64 a 10-Jan 28 48 87 a 20-Jan 71 …

## Variable sheets shown

Can I use “Selection button” to select which sheets are shown in MS Excel? For example I have buttons 1, 2 and 3. Selecting button 1, it shows …

## Copy any text into another cell

I am attempting to analyze a range of 5 cells. If they are blank, then I want the answer cell to remain blank, but if it contains a word, then I want that word …

## Conditional formatting a date in reference to another date.

I have the task of conditionally formatting a date in a cell in refernece to another date. What I need is that when a date is intered in the blank cell if that …

have no idea how to figure out a formula for this, it’s for vacation accrual: After 60 days employment, you are alloted 3 vacation days.  On your 1 …

## excel 2013 formula help

Hello,  I am trying to formulate the addition of c1+d1 if it is >= 171 then e1 is added to the sum with f1,g1,j1,k1 and totaled in l1.   if any of …

## identify three times of the day

I need to calculate wait times in the morning, afternoon and evening.  I have appointment times from 8:00 AM – 8:00 PM and need to break the time up …

## design mode issues

hope you can help? when i try and insert a live calender into a worksheet in  excel 2010 and i come out of design mode so i can use the said calender the …

## IF together with SUMIF

Hi, Is it possible to have an IF formula together with SUMIF? What is wrong with my formula below? Want to use one SUMIF formula if a cell says Style and …

## Excel Query

Hi, I work in Finance. My goal is to use the formula to make the “total receieved” which contains the formula =SUM(L22:L25) to NOT take into …

## Can You Help Fix Error

Hi There, I am trying to write a formula that says that if logical 1 to 7 is all met then it returns an answer of M and if one entry is not true then equal …

## Chart Shape in wrong position

I am trying to position a shape in a chart in Excel through VBA and although I have set the parameters of the position correct the result is the shape …

## Counting sets in excel

I have made an inventory of our printer toners, i just want a formula to count if 4 cells have 1 of each then it should display 1 set and so on. Example: …

## Will Excel calculate difference between two columns ONLY when both are filled in?

At work, running Windows – Excel 2016   I dispute over-billed invoices and have a spreadsheet that I need to calculate the difference between two …

## Text Between Commas

I have the following text string in an excel cell:  11206-72, 10031-41, 40456-54, 10039-51, 10278-19   I want five separate equations that will …

## Returning Max Date

I’m trying to create a formula that returns the max date in a row with three date columns. Some of these dates are the same, so the max date formual …

## excel to Shared calendar appointments

Hello i am desperate need of some help!i have the following code that works for putting appointments into my own default calendar in outlook, however i require …

## Row/Column Comparison Help

Hello all, I am trying to find a function that will tell me if a row in Column A contains ANY of the data in each cell in Column B and have the Yes/No be …

## #Div/0

How can I add the IFserror to the following formula.  Need to get rid of the#DIV/0. =IF((F9+G9)>E65,E65/(F9+G9)*2,E65/(F9+G9+H9)*3)   By:

## FIND AND PASTE IN ADJACENT CELL

HI All, Please help with the Following Query, I need to find a list of Strings in a coloumn within a separate list in another sheet, and if the string is …

## Find list of Strings and

HI All, Please help with the Following Query, I need to find a list of Strings in a coloumn within a separate list in another sheet, and if the string …

## Condition formatting.

Hello, I need a solution in spreadsheet. I am trying to join a couple of cells in WPS Spreadsheets with an IF statement. For eg. IF value in cells K11:K2000 is …

## SUM formulas

I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet.  Some of these values will result in a blank because …

## Low, Medium, High cross check table

Hi, i am needing help with a formula that would allow me to lookup a Low,Medium, High that relates to a table of percentage. I need it to work out from the 3 …

## ICT Technician

Hai, I need Remove the spaces in (E X C E L ) How to remove the spaces? By:

## Generating hyperlinks from a command button

I am creating a database in excel 2010 for my office. I have set up a sheet that will generate a new user. When they finish completing the new user page and …

## I need a formula

I need a formula for Start Date 06/10/16         End Date 07/05/16 Include end date in calculation (1 day is …

## countif with manny criteria

This is long shot but hope someone can help out. What im trying to achieve is a formula to calculate the average of a range of cells using the countif …

## Combin function

In excel, =(2/10)*(1/9) gives the same value with =1/combin(10,2). How do i make =(4/10)*(1/9) into a combin function in excel?By:

## IF function

=IF(‘Daily Sales’!I7:I12=Stocks!H7,’Daily Sales’!B7) Sheet1 is Stock Records, Sheet2 is Daily Sales Records. I use =Concatenate to give …

## Conditional formatting help!

i want to put icon set for a cell on two condtion. for example my cell for icon set is A2 and i have another cell A3 which contain some value and which i want …

## code skipped – no value picked in dynamic range – delete

My code give below is intended to do the following Select A1  Select A2:A10 , delete all values in this range Select A11 Select A12:A21, delete all values …

## Vba code

I have a range of columns that I sum at the last row. The code I have runs from col 3 to col 6. Because my columns vary I want the code to run from col 3 to …

## Conditonal Formating to meet multiple criteria

I’m working on a project timeline in weeks.  Columns H-BG contain the (calendar) week numbers (1-52). Columns C,D,E,F will each …

## DATE when a student must exit IF statement

I am trying to create a spreadsheet that will say what year a student must exit school.  A student with disabilities must exit by the spring of the …

## Multiple mathematical expressions

Please, am trying to compute the taxes due using the IF function The idea is that when I get to the Taxable Income of an individual, the next column should be …