## Average of percentages

Excel novice here. This may be very easy, I could be doing the wrong math. I’ve made a spreadsheet to track dollars and other sales levers per hour. …

Excel novice here. This may be very easy, I could be doing the wrong math. I’ve made a spreadsheet to track dollars and other sales levers per hour. …

I wrote the following formula and it works for 11 of the 12 months. I cannot get it to work for January. It is written the same way except for the last …

Dear Team, Just tell me regaridng the command of GREATER THAN & LESS THAN. I have core i3 dell laptop. but i don’t know that how i put the greater …

I’m working on a spreadsheet where I would like cells to be highlighted if the date in the cell is 30 days or greater from today’s date. …

I need to assign an actual Excel command to a button or shape. In this case a button with the Excel BACK command. This is not the “previous …

I have a user function that I have been using to seperate numbers out of a text string but I have noticed that when the workbook is open that contains the user …

What I …

Hi There I have Problem With Attached Picture Which I wanna cell I4 Displays The Name Of checked Discipline Even Several Discipline Checks Notice For …

I have a spreadsheet with 3 columns. Columd (C) has all negatine numbers in it. I want to add a nhew column (D) where I can enter a value and want it to deduct …

We have shared drives at work with macros in different excel spreadsheets. These macros work fine for my colleagues, but not for me. I am using the same excel …

Three files: One Excel file that I track inventory (MasterInv), and two auto-generated CSV files (CSV1 and CSV2). I set up Task Scheduler to open all three …

Hi Excel vba champs, I have built the code to extract rmail detsils from outlook mailbox from selected folder. It worked for the first run and …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

I have a set of rows with a start time and end time each. Each row represents the duration for usage of a resource. What I need to understand is …

what is cells(,5) equal to ? By:

I am using Excel 2013 I want a formula to tell put in F2 “A”, “B”, “C”, “D” based on a number in B2; the …

I have two cells which has functions which will give me results as OK or reason for the error, And I want to have third cell to complare both cell and if not …

Good dayNeed assistance on organize/ filter. i.e for examplelist of names starting with A should be rated as 1 in next column and all names starting with B …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

I utilized the ROUND function for a total in cell D30. I have another cell referencing D30 in a formula and want it to reference the rounded number in D30 …

Hi…I’m trying to embed a .csv file to an excel sheet and then delete the source file using Windows 10 and Excel 2016. My code embeds the …

Hi Can you please help me as i have made a patients data mentioning the disease now i want the disease data to change in icd codes which i have in other excel …

I have a summary sheet where I’m trying to create a list of all of the people that meet a criteria. That formula is working, but it is giving me …

I have a column where some have £ amounts … how do i get a total sum to pick out only numbers with a “£” in front? By: John

I want to create a single formula that combines the two formulas together: =IF(E1>500,500,E1) and =SUMIF(A1:M10,”Y”,E1:E10) Basically, I want to …

I want to populate multiple values in a column based on different condition.. I have constructed a Excel formula, however, only first part of the formula is …

Hi, I’ve got 2 sheets with common column A. If the cells in column A of sheet 2 match that in sheet 1, I want to copy the data from sheet 2 columns B-J …

In one sheet i have this data A APPLE B BANANA C CROW D DEER E EGG F FISH G GOAT H HUT In another sheet whenever i write A in a column, …

Hello, Please advise on how I can group my dataset. My current dataset: Name T-shirt Size Ali Small Ben Large Thomas Small Cindy Medium Lee …

Hi. I am looking to see if there is a way we can create a pick list in excel, and also as soon as the pick list option is selected the page layout changes. For …

Hi there, I have a roster where i want to implement conditional formatting. If you see my roster below, you will see the green and red …

Is there a formula in Excel that lets me assign a number value to a text word? I’m making a weekly travel log for my mileage and want to assign the …

Hi, I was wondering if there is a way to enter dollar values into excel without having to enter the period? For example, if I want to type $1.38, is …

nike air jordan superfly 4 ponike dunk high sb pro 881758 110air max 2017 jumiaadidas tubular moc red off white x nike air vapormax 2 0 red black 2018 …

I need to merge two sheets data in one. I have two sheets with some common data in a column. I want to add data from one excel sheet into another in front of a …

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days Data structure: Column F – …

Current formula i am using: …

Hello, I have graphing problem. I wanted to know one particular thing about graphing, and I guess I messed up something, so that I can not even graph …

I have a workseet In Cell F7 I have Total Population size In Cell H7 I have Total Sample size on H7 i have applied data validation as “value in H7 …

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.