Is it possible to auto-fill a column of cells dependent the rows in another column?

Hi All,

I'm in a situation where I have a number of formulas in place that are dependent on data imported from another source. As the row count for the data will be of varying lengths, is it possible for excel to understand what the last row is a value exists on in column C, and from there, automatch the formula to that row in column D to meet the final value in column C? Preferably this would occur when the data in column C is imported

I understand dragging down for say 100 cells in column D should cover the imported data, if, for example, the maximum rows will always be between 70-80. The issue with this is, a 0 value will be returned, which will affect other formulas on my spreadsheet. 0 values for that column can't be set to not showing, as they may show up earlier in the column, which is data I will need to have showing.

Thanks in advance.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Perhaps Try

C2=IF(B2="","",B2*2) and drag down

It will be good if you can upload actual working workbook with expected result.

Try

K2=IF(((D2+E2)/V$2)*G2=0,"",((D2+E2)/V$2)*G2) and drag down!!!

It will take care all the things. When the cell will have 0 value, it will self convert them into blank cell and don't affect to average formula.

Ok

Try

K2=IF(ISBLANK(B2:G2),"",((D2+E2)/V$2)*G2) with Control+Shift+ENTER

Glad to help you

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED and add reputation click on star * icon left corner on your screen. Thanks.