Get instant live Excel expert help with Text Functions

Assigning numerical values to non-numerical text and finding the sum of multiple non-numerical texts that have been assigned values

Hi there, I'm looking for a formula to match a text within an array and return the results found. I know how to you use vlookup/match/index formula's, but I can only return the first match found. I would like to return the first match in cell A1 and the second match inside A2, third inside A3, etc. So when the first match is found and placed inside A1 then the formula inside A2 should ignore the first match that is already found and show the next match value. I would like to get this done with a formula and not with the autofilter option inside Excel.

I would like to create an IF function formula that shows text in a cell(f5) if another cell shows text in another cell (c5). the text in Cell c5 is a drop down list with multiple options can this function be used with multiple texts?

2 sheets On one i want to pull the following from the other Column A contains a text in the cells Based on a specific value in column A, i need the value in column b pulled into the other sheet.

I need a macro that will flatten rows of data based on text in a field - there's a "like this" tab on the google sheet. I have 1000s of these files so I need something that will work generically.

How would I write a formula that says "For an entire column, if a cell has text in it, and the cell above it is blank, copy the lower text into the blank cell above it."?

I need a formula to use if in a column, if there is a cell with text in it, and the cell above it is blank, copy the text from below into the cell above

Hi, Need help with a quotation speadsheet to be used by staff to stream line our operations, In the top bar i want a drop down list of the 3 types of sales option, this will then bring up a drop down menu in the column labelled 'product', with the price for each product appearing in the column labelled 'rate'. Each sales option has different prices for the products. All 3 options and products lists with prices are in tables in worksheet labelled 'products'. I have already had one done by you guys but all the text in the drop down menus aren't correct

Trying to use a table to have an excel function looking if one cell contains certain text, then to output a word that corresponds

I'm trying to create a table to make a function where I check if a cell contains certain text so i can output corresponding text