## lookup and reference

Find all the values in array1 that correspond to a number in Array2, i.e., for # “8”, the return would be “Al”, “Bt”. For # …

Excel 2010 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

Find all the values in array1 that correspond to a number in Array2, i.e., for # “8”, the return would be “Al”, “Bt”. For # …

Hi, I would like to know what formula we can use to get the forcast of the PRE QA numbers from the disqualification trend we are having? for example: if …

I’m doing a spread sheet which involves circular references. The iterations function has been enabled to allow the circular references to work. Basically …

Im using windows 10 and excel2010 I am trying to come up with a formula that finds the highest ascending number in a sequence, the numbers are across columns …

i’m still relatively new to excel. i’ve been working 15+ hours on this sheet and figured there must be a faster way to do this. essentially, …

I have a column of 6 cells and I only want the top 4 summed up in another cell, how can this be done? By:

SEVRENE® 3000-70A-8870 XDV DARK SLATE Is there an If statement that would pick out SEVERENE from the above, change SEVERENE to SEV in another column, and …

I want excel to pick the two largest of three numbers where the cells are not adjacent. Example; total two largest numbers out of D4, G4, J4. Thank you for …

I have to convert around 40,000 numerical codes into text and I would really like for a formula to help me out. These are labor codes for example, labor code …

I have a Spreadsheet with multiple pages for quoting and pricing equipment. It’s basically a program I setup with pricing so I can copy and …

I need help with creating a formula that rounds the rank of a person up for a tied Count. Situation: “Name 05” has a count of 9. The formula needs …

Hi everybody. I want to write a formula that gives me the value of a cell. I’ll try to explain: cell A and cell C have values 1 and 1, respeyively and I …

Hi, sorry, exhausted all searches. I want a formula to tell me if the IF function result is the true or the false result. A very simple example, I have: …

i need a formula to show a specific cell if anothe cell value is between 250 and 280 By: Francois

I’m not sure if this is possible, but it probably is but I just don’t know the formula. I’m trying to reference a tab in excel …

Hello In the format below, how do I display the numbers “Under” as “-” and “Over” as “+”? With + in …

## we found a problem with some content in ” file name. xlxs” .Do you want us to try to recover as much we can? If you trust the source of …

Hi, i have a data to sort by using linear interpolation. Let’s say i have Age Value 1 5 2 6 3 11 4 13 5 6 7 8 9 and 5 to 9 is given the only the …

I need the formula to combine column C with the number mentioned in column L26 to L32 By:

Hello,Can anyone show me how to write a formula that will find the MEDIAN of a group of numbers in one column related to specific criteria in another …

Hi, Can you please assist how to change 5-Jan to 1-5 in excel 2010 without ‘ before the numbers By:

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545} Hi: My name is Jose. I know Basics Excel, not an expert and I encounter a …

I have excel 2010. An excel sheet that has many companies production during each day of the month. I need it to summarize automatically the names of the …

I have a table with these columns: Company, Person, Last Contacted. Now I want a table with all COMPANIES where no Person was contacted in the last 3 …

How can you delete numerous records on a filter without deleting every record in between. Say we have 40k records and we want to put a filter on that displays …

how to create a drop-down list of names that will update the chronological order based on the name selected for multiple columns? By:

I have a txt file that is exactly 500 characters wide and can have several thousand ‘rows’ of data that are also exactly 500 characters wide. …

Hi, I am looking for equation in excel which subtract 4 from different numbers so as to get a reslut rest number “not in minus and zero” …

i would like to calculate the following: if any value is entered in 1 cell then the corresponding cells value should be -1 By: Eric

Hi, I need help in creating a multiple if statement with text & a wildcard. I have an existing formula that works, here, …

I am trying to count uniques values in a column (say Column A) so not to include any duplicates. However I only want to count the values if the month in a …

I have one employees exel spreadsheet with location data. I have a second empployee excel spreasheet that lists if they are management level or …

Hi, I am working on a file where i have to make sure that two columns have the same data. The issue is that the data is not arranged in the same order in both …

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation. I …

Hi I have a question about how do I explain a negative percent for sales that is positive compared to negative sales the prior year? Last sales was a …

Hi I have a question about how do I explain a negative percent for sales that is positive compared to negative sales the prior year? Last sales was a …

I am trying to build a spreadsheet with a table recording monthly (rows) business takings by year (columns) that will apply conditional formatting (red and …

Hello I have a table in excel like this: A | a B | b A | w B | z I want to transform it into: A | B a | b w | z Is there any way to do …

I am trying to write a function that has a black out in time. Currently G4 displays a time that text was entered into F4. In the next line, I …

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.