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

I am trying to find out how many people are working within certain times of the day with intervals such as 4:00-6:00. I tried using COUNTIF and SUMPRODUCT but they did not work

Solved by B. J. in 11 mins

I'm trying to find a formula that would automatically calculate -8 in column F when column C is either Yes or No as well as the total % for that category.

Solved by B. F. in 15 mins

I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.

Solved by M. A. in 29 mins

Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part.
I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout.
Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information.
If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly.
How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.

Solved by F. C. in 12 mins

I'm have two columns with different values - one column has country names, another column has Y (or is blank). I want to find a formula to count the specific name if there if there is a Y in the same row as a country name.

Solved by B. J. in 19 mins

Two columns of data containing names. I want to make excel find duplicates in two columns, can you help?

Solved by Z. D. in 29 mins

I need to find a list of possible values within a sheet. For example I'm looking for the values of Dog, Cat, Snake anywhere within another sheet on that same workbook. Once found it, I want to learn how to highlight cells in excel for these cells.

Solved by G. W. in 21 mins

What formula do I use to search for a particular row for an event and when the criteria is found, calculate items in the column below? Example:
Row 5 contains the sales price of a building ($1,500,000) in a cell between Columns M and X; the calculation needs to find the cell containing $1,500,000 and then calculate the the NOI contained in the Rows 20 - 30 in the same Column as the cell containing $1,500,000.

Solved by I. B. in 25 mins

I am using a MS excel. I want find sum of two largest of sum of columns. So please would anybody help me in this?

Solved by A. C. in 21 mins

trying to have find excel vba to find a field and only return the portion after it in a new location that i want

Solved by O. A. in 21 mins