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

I was jut receiving help from a spreadsheet expert. He/She was able to create the right formula in cell F2, but now I'd like to figure out how to easily take that formula across column 2 without having to type in date and time criteria for each cell.

Solved by I. W. in 24 mins

I need to write a nested if statement. I have to identify those with a value greater than 0 in column A but have a zero value in columns C & D to return a value of "Lost" if the criteria matches and Active for those that dont match.

Solved by M. D. in 22 mins

Pls see attached sheet. I need a formula in the “TOTAL YEARS (REHIRES ONLY)” column, which will add I2:I3. I'm having a hard time because I2:I3 has a DATEDIF excel formula already in it

Solved by E. J. in 19 mins

use of solver
To best match the group
with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable).
Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each
group receives no worse than their 6th best choice. Two groups have specific needs and have requested a
particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs
to use the Refactor Room. To complete this task, you should use Solver.
The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten
meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table
indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not
been assigned. Only one meeting room can be assigned to each group and each group can only reserve one
room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells
will contain the value 0.
The values in the preference value column should be no greater than 6 indicating each group will receive no
worse than their 6th best choice. The preference total cell is the sum of these scores.

Solved by S. C. in 27 mins

i would like a macro that goes through all sheets except 'main'. in those sheets, loop through column D to find any blank cells and fill them with "0" (highlighted in yellow). Then find the last cell containing data, and fill the next blank with "0" (highlighted in orange).

Solved by F. A. in 30 mins

Hi, we have an excel file with five columns. We need HTML to be inserted before and after each column. It's the same HTML for all. Then we need all five columns to be combined in one column. Attached is the file.
Please Advise
Thanks

Solved by O. E. in 26 mins

I want to make the cell column width different of various parts of the sheet

Solved by Z. Y. in 18 mins

Hey, my excel column says July but on the chart it keeps coming up as April? why

Solved by X. J. in 13 mins

i need such a formula so that i enter figures in one column and their addition should be result in another column.as it upto date with next day entry i send 2 sheets kindly check it

Solved by C. J. in 15 mins

I am trying to remove duplicates in column A and add the data from the duplicates in column B and compress it all into one row.

Solved by K. H. in 12 mins