Get instant live Excel expert help with ROW Functions

How can I use VBA code to return the row number of the last non-zero value in a column

I have a large spreadsheet, 3000 or so rows. In one column I have company names, the first row has information about that company (address, phone number), followed by rows for every purchase made by that company and for how much. Is there a way to automatically apply the company information on the first row to each subsequent rows listing the purchases?

Hi, I'd like to create a summary document of the data that is fed into the attached spreadsheet. This information is fed through an API coming from an online store. The orders are all displayed in one row, so for example, in cell D1 all the product SKUs ordered are displayed and in A2 the quantities. On the tab titled, Copy of Oakland Fulfillment Manifest I want to sum up the orders that are for specific delivery dates that also have a specific SKU - cell D1.

I want to run a search for value "Item Text:" and return the value 3 cells below it Say Item Text: appears in cell A46, I want to return the text in cell A49 into a table I need to be able to drag the formula down to account for all instances of Item Text in the whole document. I have other values that are directly across from the search value and I am using this formula: =INDEX(Raw!B:B, SMALL(IF($N$1=Raw!A:A, ROW(Raw!A1:A20000)-MIN(ROW(Raw!A1:A20000))+1, ""), ROW(Raw!A1))) but I can't figure out how to get it to return the value 3 cells below instead of to the right

I would like to create a formula or macro that can search my sheet and find in Column F any cells that contain the exact phrase "WCMSA CMS Submission", then I would like for that row (row 7 is one example on the attached sheet) to be highlighted. And then, I would like for any additional rows that have the same value in Column D as the value in D7 (or any row that was highlighted due to containing the appropriate phrase in column F) to also be highlighted. Row 3 would be an example that should also be highlighted since it has the same value as D7, which was highlighted because of the value in column F. I'm stuck!

I have a master sales doc. Every month I insert three columns to input the current data. I have made a separate sheet that displays a specific section of that new data by partnering each cell to its relative one on the master doc. So when/if I changed something on the master it automatically changes on the other sheet. My problem is when the next month rolls around and I insert three more columns the partner cell moves with the previous months data. EX : the formula for the partner cell(A1)(Separate sheet) could say =F1(From master doc.) source location but if I insert a new column in master doc and F1 changes to G1 the other sheets formula changes to =G1. I would like it to lock on that specific cells column and row if possible so every new month i can input data on the master doc and the data automatically shows up on the other sheet. Hard to explain sorry. Please help if possible.

I have to read rows from a specific row no to the end of an excel and write the values into the mysql database by doing column mapping since the column are not in order.

I have a file with 6 months worth of data and I want to calculate the number of entries in each row that are blank or less than 2. How do I do this

I'm trying to create a table that calculates averages based on other cells, but I don't want to include the cells in the same row as each average value

I am trying to work on a google form and the spreadsheet that records the responses. I know that when it records the responses it adds a row to the spreadsheet therefore my formulas don't update. I tried adding a sheet to the workbook called Total Due and using the query function to pull the data from the responses but it doesn't seem to be capturing everything and need help in getting all the data to pull from the responses over to the Total Due worksheet.