“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by B. B. in 21 mins

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

Solved by D. S. in 17 mins

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

Solved by M. H. in 19 mins

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

Solved by K. A. in 29 mins

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

Solved by S. Y. in 28 mins

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

Solved by I. J. in 20 mins

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

Solved by M. H. in 19 mins

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?

Solved by T. Q. in 13 mins

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.

Solved by F. E. in 13 mins

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

Solved by C. U. in 22 mins