## product list question

On the right side I have a list of products and revenue and on the left there is the total is there a way that the left side is populated with a …

Microsoft Excel Formulas in Excel

On the right side I have a list of products and revenue and on the left there is the total is there a way that the left side is populated with a …

How can I change for this information: Column A Column B1 company1 Item12 company1 Item23 company1 Item34 …

Hello, Having a little trouble with a few different formulas. I have multiple sheets with the same data and data range. Column 1 = a skill name (with multiple …

Hello, I have a table containing temperature data (in Degrees Celcius). Data is organized as follows: A) Date and Time (mm/dd/yyyy hh:mm:ss) …

A1 = “Hello World!” in bold. In cell A2, there is a formaula =A1. I want A2 to match the formatting of A1 but don’t know how to …

Hi Yesterday I am using the excel. My boss gives me a challenging job about excel. I have a List i.e. Sr. No Code No. …

I keep getting this eror messsage, please help me. By:

Hi, I am trying to use a wildcard in a formula but it is producing a result of ‘false’ instead of the answer. If i remove the wildcard the formula …

Hello, I’m helping my dad manage his finances, and I’m trying to use Excel to help him do that. Here’s what I need: The image below shows a …

Is there a formula that I could use to look for matches (text) within one cell and place an option of values in one other cell? I am trying to attempt to match …

I need the formula in Col E to look at Columns A-D for any number/amount, and if there is, then copy what’s in the header of that particular column. …

I have a spreadsheet I use for testing appliances. Each row is for a different appliance. When I Pass an appliance, I would like the date a year from now to be …

Sno, inv no, paymentl mode, amount 1, 200, cc, 50.00 2, 201, cash, 120.00 3. 202, cash, 24.00 4. 203, cc, 1588.00 I want formula for to separate the …

Sno, inv no, paymentl mode, amount 1, 200, cc, 50.00 2, 201, cash, 120.00 3. 202, cash, 24.00 4. 203, cc, 1588.00 I want formula for to separate the …

hello there, I have several names in a culomb (sorry for bad english), and pics in the culombs next to it. for ex. in A:2 I have X and in B:2 X’s …

Hi, I have a very large spreadsheet with many columns and many rows. It’s a training matrix for a team of employees. Some of the coumns have dates that …

Having two excels with the same spreadsheets. While changing one spreadsheet, I want to know how can I do to just change one excel and automatically the second …

Hello everyone I have a problem where I have two rows and 20 columns, I need to calculate how many columns in either first or second row have number. Sorry for …

Hello everyone I have a problem where I have two rows and 20 columns, I need to calculate how many columns in either first or second row have number. Sorry for …

Hi guys, In brief, i have an example, where i have 20 stores (Column A, Store 1 being in cell A2 and Store 2 being in cell A21), in each store there is …

Need help to do following steps with formula or vba code …

Hi there, Need help with a formula. Here’s what I’d like to do… imagine in one cell, comma separated values. Like.. 5,+ The next cell …

Hi AllI have a formula, that works! (Hooray!) But only with a manual entered INDEX array..The working formula …

I am trying to create a formula but really struggling! I’ll attempt to describe what I’m trying to do: Worksheet1 A1 value “Apple” Look …

Hello Sir/Madam, Im wondering if youd be able to AID me with an issue im having, im not even sure if there is a work around. Background i have been tasked with …

hOW DO I WRITE A FORMULA TO CALCULATE IN EXCEL C2 CELL if B2 = X THAN PRINT X IF NOT THAN CALCULATE =SUM( B2*100)113 By:

Good Morning (from) Vietnam. I have a lengthy spreadsheet with parts prices. What I need is a formula that finds a range of amounts – for example, a part …

KAUN BANEGA LAKHPATI NAME LIFE LINES USED ANSWER AWARD 50/50 TELEPHONE AUDIENCE RAMESH T F T DINESH F F F UMESH …

I have an excel spreadsheet with 3 tabs on the bottom. The first tab shows a summary of the invoices, dollar amounts, and patent #’s and different …

Hallo Clever People, I need to take the following data: Object Field Low High Node S_TABU_DIS ACTVT 1 18 S_TABU_DIS ACTVT 2 18 S_TABU_DIS ACTVT 3 …

Hello, I am attempting to do the following: -Count number of rows where B2:B152 = “T” and G2:P152 contains any data. I figured out that I cannot use …

I’m trying to use vlookup to return formulas instead of values from another workbook. I already tried the eval function with vlookup but it does not seem …

I have two spreadsheets. I want to make it such that if cell a1, b1, c1 in sheet 2, all match any 3 cells in columns a,b,c in sheet 1 (all three have to match) …

I am trying to create a workbook for my company to decide who has gone through and completed something that needs to be done. I was wondering if there is a way …

Hi I want a formula to show the number of work days between a added date and until finish date. However Finish date will be blank I want the formula to …

Good day I have tried vlookup and index/match functions to help me determine the “fees” when entering the grade. E.g. GRADE Fees RRRR …

i want to select unique random value from a data based on two criteria. By: Satwinder

Hi, so i’m trying to create two drop down lists. One list is dependant on another e.g. select Yes from the first list and this should show a new list in …

Please help me with the formulae . I have a data , where i need to highlight the cells using conditional formatiing . The criteria is : Highlight …

I’ve created the below countifs formula. Here is the formula that …

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.