Get instant live expert help with Excel or Google Sheets

Looking for help using excel to match part numbers in two different sheets, and having excel automatically enter quantities ordered and received of that part into one sheet without any extra effort. looking to make a template for expediting the purchasing process. also need help making a total sheet so that specified sheets copy and paste into one sheet automatically.

Need help. I'm creating a simple spread sheet I use for appraising homes. I've never had this problem before. I enter a number into a cell, 1,200,000 and then format the cell to Currency and change decimal to 0. I should get $1,200,000. But excel for some reason drops two last zeros and I get $12,000. No matter what I do excel keeps dropping the last two zeros. What am I doing wrong?

Hi: Here is my problem and I do not know which function to use to solve for it. I am an intermediate Excel user (my definition). I have a column (Col A) with many rows with email addresses. There may be duplicates for good reason. Let's call that data X1, X2, X3, X1, X4, X5, X2...by row. I have another column (Col B) with many text fields. Let's call the data by row in that column Y1, Y2, Y3, Y1, Y4, Y5, Y6, Y3,...there may also be duplicates. The X data are associated with different Y data, hence the duplication of email addresses (X data). for instance, X1 on same row as Y1 but X1 is also on a different row with Y3 and maybe a different one with Y9. What I want to do is to look up each unique X variable and associate it with as many of the Y variables as match it. So, my hope is an output that looks like this: Col A Col B X1 Y1, Y3, Y9 X2 Y1 X3 Y2, Y4 or Col C Col D Col E Col F X1 Y1 Y3 Y9 X2 Y1 X3 Y2 Y4 Can you help me?

I need help with a formula in excel for my spreadsheet

Hi could you help me please with an overflow error? I can send you my script in a word doc but I am not allowed to share the excel doc. Would the word doc help?

excel pro needed to help create a macro to automatically create a total sheet so that when new sheets are added, they automatically copy and paste into the total sheet

I am trying to write a simple pension calculator for my colleagues, much of which is done, but I'm having one specific difficulty. The 3 key elements are: 1.The age of the person at the time of retirement in years and months. 2.Their salary at the time of retirement 3. A commutation factor ( a multiplier found by refering to a seperate table with years and months on the X&Y axis respectively. Where these figures intersect provides the Commutation factor ) My table works in so much as the colleague Manually enters his/her date of birth and date of retirement and this generates a cell with their age AT retirement. They manually enter their salary in a new cell And then have to refer to the seperate table to identify their commutation factor ( by finding the figure at the intersection of their age in years and months. this has to added manually, thereafter it all works fine and the figures are correctly generated. I am sure there must be a way, but have failed miserably to find it, of automating the population of the cell containing the commutation factor, once the age in years and months have been entered. It is no great problem to look this up manually and enter it, but even as a relative Excel novice, I'm sure this can be done and would tidy up my table completely. PS/ I have the commutation table sitting on a seperate worksheet currently, but it could sit on the same sheet as the main calculator if necesary. Is this something you can help me with. My colleagues are content with it as it is, but I'm not, because I know it can be better.

Need help making a formula. I want to scan a product code into a excel spreading and If the barcode does not exists anywhere, then sound a audible sound. Then start again.

Hello, I'm trying to skipping rows when auto filling (drag down) in excel... can you please help me find a formula that references this number of skipped rows?

I have a table (9 rowsX 4 columns). I need to summarise this table using excel formulae. The rule states: "The 'Occupancy Description' of the building (within the location) that has the largest value of the 'Area Sq. Ft' should be the 'Occupancy Description' of the location" This should be done using pure excel formulae (no macros). Do you think you can help?