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

The Pit # column was formatted into a 4 digit number to maintain the leading zeros (all pit numbers are 4 digit numbers). However the data needs to be manipulated to combine columns pit number and pit name (as seen in A32 on SA1 workbook). Is there an easy way to convert pit number column into text while maintaining the leading zeros?

Solved by T. C. in 25 mins

Trying to populate a column in Excel via VLOOKUP but not generating

Solved by Z. B. in 21 mins

I need to sort one column with text based information based off the sorting of a column with values

Solved by I. A. in 16 mins

I am trying to see if the items in column A are also included in column B.

Solved by A. U. in 12 mins

Calculating 10% then reducing a column of numbers by that calculated number

Solved by D. A. in 29 mins

I need to take the amount due from subtotal column then multiply by .1 which is 10% then divide by 12 to get the interest due per month. Then multiply by the number of months then add to subtotal to get the total due.

Solved by T. J. in 25 mins

need help suming certain data from a particular column.

Solved by E. U. in 18 mins

I would like column E2 to sumif based on the sales rep in column D and the date range in Column A based on date in Column C

Solved by O. E. in 20 mins

Im trying to make a formula stating if a cell within A:A equals a date in january AND if a cell in column E:E equals "X" ,count.

Solved by S. J. in 11 mins

I have a data with 4 columns
I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here
IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row

Solved by G. U. in 22 mins