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

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 …

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 …

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 …

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 …

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 …

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 …

Good morning, I’m wondering how to write the formula …

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 …

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 …

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 …

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 …

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 …

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 …

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

Alt+ tab not to work when userform open in excel vba By:

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

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 …

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 …

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 …

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 …

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:

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 …

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 …

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 …

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 …

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 …

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

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 for Start Date 06/10/16 End Date 07/05/16 Include end date in calculation (1 day is …

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 …

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(‘Daily Sales’!I7:I12=Stocks!H7,’Daily Sales’!B7) Sheet1 is Stock Records, Sheet2 is Daily Sales Records. I use =Concatenate to give …

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 …

i want to automate my excel report sheets,please share with out VBA or macro using ? please help… By: Agha

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 …

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 …

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 …

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 …

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 …

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.