## Cell Formating

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 …

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 …

I am trying to conduct a weighted evaluation on different services. The top mark for each offering by this service is 1.00. My likert scale is 1 = very poor, 2 …

Hello All, I have a set of data where in there are several dates (For eg in cell A1) and alphabets (in cell A2). When I don’t have the alphabets in …

I wonder if someone can help. As commonly knowing when looking at bank statements clients tend to put their invoice number or account as a ref. I then look the …

Twenty students in race heats, and 4 in a final, to decide the champion 100m runner. I want to rank four Times in excel and I want it to be 1= champion, 2= …

I am working with data from a relational database exported to excel. A 6 digit code in one cell will drive what codes go into the other cells. The third, …

Pls, help. How to populate Amout data in calendar fiel in right table from left with date on/off condition? 2016 2017 Amount date on date off …

Hi all 🙂 I’m hoping someone here can help.There’s no Excel 2013 help option. I have three sheets in my workbook. In order, they are:Search …

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.