Get instant live expert help with Excel and Google Sheets

Write a procedure to list out the states and their headquarters. The output should be one msg box with the state and headquarters listed.

Create a new conditional formatting rule that displays any Inventory Value for the Food & Health department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries. Note, Mac users select the range G2:G78. Then in the New Formatting Rule dialog box, select the style Classic.

I am saving a document in .csv format and when I close and open it back up, all of the information from Cells A-E are all shoved (with NO SPACING AT ALL) into Cell A.

Hi, I need help learning how to do these formulas

Hi. I am trying to find a way to INDEX/MATCH to a partial string within a table, I can't seem to get this to work. I have an example workbook available if needed. Thanks

Hi, Please see the attached spread sheet (notifications, add more stats, add some trends showing changes to different type of notifications over months and finally design a dashboard, pretty much same as medication spread sheet

I have a list of names with associated information in one worksheet and same names (maybe a fewer) in another worksheet... all in the same workbook. I need to pull information for a name in worksheet A from same name in worksheet B. How can I do this efficiently?

I have a spreadsheet full of clients with allotted hours and used hours. I want to be able to find out who used 76% or more of their hours on one side of a graph/chart and which Clients used less than that in the other part of the graph/chart.

Hi, I'm trying to update cells on one sheet depending on various criteria on another sheet but nothing I have tried so far has worked.

change the order of file from descending to ascending order