## Adding Hours for Tech Support

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

I have a list of work that has a date received column and a two week deadline date column next to each other. I then have a date completed column which …

Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …

If i have 2 different sheets with 10 headers (eg “Coustomer name” “invoice number” and “insurance name” etc). I was to copy …

Hello this may be a long shot but I need some assistance with data validation. We are currently using a new tool to automate firewall requests in our network …

Can anyone help ? i Just want this … Code Name Quantity 111 A 5 112 B 6 117 G 1 113 C 4 114 D 2 111 A 5 115 E 3 114 D 2 116 F 2 117 G 3 … to this …

If I wanted to fill a certain number of cells according to a number. How would i do this? For example cell, B1 is 5 And I create a box then I say that I …

Hi, I am trying to analyze my accounts easily and I would like to locate a specific item from one column and the amount spent on that item from the next …

Hello! I am working on a delivery schedule. I want to match it with the delivery history to find the previous cost. What I would like is a formula that matches …

Suppose in sheet1 :: mango in A1, egg in B1, fish in C1. All these in row 1 Now in sheet2 ::: D5 contain formula =sheet1!A1, A7 contain formula …

Hi, I have a unique values in column A and related times for each of the unique value in column B. The times recorded for the unique values may vary …

I have a spread sheet which currently has 600 rows and 225 colomns… I have 10 main columns for detail sorting and then 215 for different Job codes I have …

Hi guys. So I’m going to try to explain this as well as I can, but might fail. I have three columns, let’s day A, B, and C. So I tried to kind of …

Hello – I have a spreadsheet of data (Excel 2016) analyzing newsletter results for our firm. Column A has client email addresses and each …

Hello Team, Please help me to solve below; Q. Conditional formatting to highlight numbers 20% above overall average and 20% below overall average in given …

I’m having the hardest time getting excel 2013 to get all the things I need rolled into one. I need to enter times in military time and know the …

Hello, I am a beginner in excel. I need some help on data validation formula. Due to character limitation, I am not able to add two more IF clause …

Hey all,I need help!, Suppose I have 15 names,and all those entries have some exact number,I want all possible combinations of 7 entries within the total sum …

Hi, I need an excel formula if cell contains text then return TRUE/FALSE in another cell. For instance, if cell B2 contains the text “large” and …

I have a 3 condition IF AND statement in my output sheet. It is looking at 3 columns on my input sheet to match the conditions. I am finding that when it …

I have an excel spreadsheet I am using for my daily production and inventory. In my daily production I use a bottle type I choose from a drop down list and I …

So I was recently tasked to take over an ongoing report by a former coworker. The report is an Excel workbook that consists of 100 different tabs with …

I need a formula that can highlight rows once certain criteria is met. Example below would be If Colum “R” is filled in for all of the same numer …

Hi all, I have been playing around with a few check lists that we hold within the maintenance team. One such is the checking of emergency exit lighting …

Hello, I am trying to do a chart and need to edit the X-Axis. I see where you can edit the increments, but is there anyway to do two different …

I have a report in which i need to add the certain coloumn and show the result only once. For example: I want to put a formula in the Total Borrower Note …

How would I insert a group of cells to a single cell value? Ex. Let’s say I have a two columns of cells. I want the cells in …

Hi, I’m currently learning more about Excel formula so that I am better at it for my job and in general. My question is, what would the formula look like …

Hi. let’s say i have 2 sheets.The first one is CE and the second is 1E. In CE cell E9 i have the number 1000, in F9 i have the number 8 and in G9 i have …

I have Excel 2016 running on Windows 10 I have searched and can’t find the answer to this problem. On a quarterly basis I add a new number to the …

I canot get my spreadsheet to vlookup a value based one a date and employee number. I tryied to use index and match but it too too long for it to work. …

Hi, I’m Jr. please i need help on how to copy a formula in excel to multiple cells within a column. For Example the formula is: =G2+I3 How do i copy that …

Below is a table that I would like to combine the multiple rows into 1 row. 10207 Albers Sue Bill and Sue Albers Home 1811 South …

you could see my excel example for calculate the bonus from each downline below their level.and tell me how to get the value automatically because it …

Required formula for below condition Final result depend on 6 column status example as below If cell A1=2, and B1=2,C1=2,D1=2,E1=2,F1=2 result 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.