Get instant live Excel expert help with IF AND Functions

Wanting to automatically generate a chart from sheet1 to sheet3 that sorts by group name AKA column 1 headings (EXAMPLE 1, EXAMPLE 2, EXTRA,) and organizes it by color green,blue,yellow, then red. *Notice* that color is based on Conditional Formatting tool and is order specific in order to give me the coloring scheme that is wanted. For now we will ignore sheet2. Thanks

I need a formula to separate and order data that I have pasted into Excel, currently all in one section (HC-One 9.4 352 CH, 1 ADC • P) and I want the number previous to CH to be ordered numerically largest to smallest

I need to formula to test my data. I am looking for duplicates with two conditions: ord instant (time) (column A) AND ord erx id (column c). The ord instant for a drug and ord erx CANNOT occur at the same time therefore it is a duplicate. Also I do not have access to google docs, I would need an explanation in the text box. Thank you

Hi I need to calculate several IF AND OR statements. 1) if value is =1 return 1 2) if value is = 2 return 2 3) if value is greater then 10 but less then 50 multiple by .10 (10%). if value is greater then 5 return 5 4) if value is greater then 50 multiple by .25 (25%). if value is greater then 10 return 10

I am using excel to highlight duplicates and order research papers for a systematic review. My initial search had roughly 300 papers. I have done a new search which includes 400 or so papers. (each paper has various columns, such as Title, authors, abstract) etc. In theory my new search should include all 300 papers from the initial search (which I have already assessed). I match these old ("already assessed") papers to the new ones to (a) highlight new papers I must assess and (b) ensure that I am not missing any papers

I need to match the serial numbers to pull the email, model and organization group in the Invoice tab

How do I expand or collapse several rows under a header in Excel?

I have a spreadsheet where row 1 is dates, spanning 3 columns each. Columns A-C are Product Name, Order #, and Case Count, respectively. D-F (repeating indefinitely) are Sold, On Hand, and Order, respectively. I want a dynamic formula applied to the whole sheet that checks row 1 for today's date and the order column for quantities greater than 0. Currently, I have =AND(A$1=TODAY(),C>0) and it works as expected. The problem is, it's formatting cells in the wrong column (relative A as opposed to relative C). Is there a way to alter this so formats relative column C?

Level A items Fruits Veggies Nuts Under each Level A item there are an inconsistent number of "Level B items" For example: Level B items Under fruits you have apples and Oranges (2 items) Under veggies you have corn potatoes and peas (3 items) Under nuts you have peanuts (1 items) I need to set something up so that I can type in a Level A Item (in random order) and have a row of data created for each Level B item. So if Sheet 1, Column A is: Fruits Veggies Nuts Then Sheet 2 Column A would look like: Row 1 = apples Row 2 = oranges Row 3 = Corn Row 4 = Potatoes Row 5 = Peas Row6 = Peanuts And so on and so on.

What apps and or API integrations (minsheets=contacts) to take my sheet to "(build with a bot made sheet to sale funnels to app/api/bot= email generator/erifyer+automated+insights+smartsheet+giphy+zapier+taskbot+growthbot+freshdesk+project insights+formatter+Zendesk+sheets+slack+webhooks+allais) needed and please of your choice of BI bot and what other apps/apis bots to create the most responsive and interactive database ever w/ embed bot/app fully able create and sort sheets maps dcs graphs & filtered data as i command so it monetized for $ philanthropic to change the world like kiwi+excelchat+insightly+BI Also Linkin url to email ethical