## INDEX Array problems

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

Microsoft Excel Formulas in Excel

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 …

I am on Excel 2016. I am building a pricing tool where a combination of text and a number/text make up a section of the bill-of-material to look up …

I have a list of 1130 bank account and i have to debit them a few charge like 10 per head and as of now i have charged 928 members randomly and i needed to …

Hey guys! I would like to know how could I assign values to text, or better said, for my “products”. I’m fashioning a drink calculator …

Good Evening I have a staff hours sheet consisting of 350 colleagues. I’m trying to find a way to populate a rota. Basically what I need is, if I …

if i want to put cell a1 3000*3 and wants to get result of cell a1 in a2 and by link (without copy & pastre) , is it possible By:

Hello! In urgent need of help! I want to be able to link workbooks (on excel). So the example is if I have say cell b2 in workbook 1 and i …

how to i convert 00 hours 04 minutes 44 seconds into a regular time lik4 04:44 in excel? By:

Using Excel 2016, how do I compare every row to every other row, and see which are most/least similar? Example: 4 rows with 6 numbers each in them. 2 4 …

I am trying to forcast a the size of an agent’s funnel of orders based on the following criteria: I know that: – Each agent will be assigned …

How to add a date match as an AND condition to sum, when the values are horizontal/rows and are not equal. They do not match in size criteria; which is …

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to …

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to …

Scenario: Column A is a list of products (30 lines) Each product is assigned a value in Column B (either “Exclude” or “Include”) …

In our computer system, we have different codes for everyday tasks. Problem is the codes are different for each division we have. For Example: …

hi i need to know if i want to enter a certain word in a cell and i need a value for that word in numerical digita in another cell, then what formula would i …

I would nee help to find the right formula for my spread sheet By: romain

Hi, I would like to ask if is there any way to add values to a cell continuously? Example: I would like for E2 to have the values of E14 summed up. Like, …

Let’s suppose we have User A .A refer B so A Earn 10rsNow A refer C so A earn 10rs Now B refer D and E so A earn (10+10=20)but B also earn (10+10=20) Now …

How can you combine an iferror formula with an roundup formula (but I need to round up 2 places)? Is there a way you can combine them? Can you show me on my …

I am struggling with an if and statement. I have 3 possible outcomes (B1000, B2000, B3000) based on certain critera. Want answer in column A, based on …

Hi, I am putting togethere a time sheet and i want to include exception codes. Specifically staff can only work between 07:00 and 19:00 and they can …

So I have a data set of lets say (for confidential purposes) doctor offices, the set looks like this; A B C D 1 Office Info 1 info 2 District Manager (DM) 2 …

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.