Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WebGenii

    Excel Cell Referencing

    The COUNTA portion of the formula counts the number of cells in the column (F) containing data. If there are empty cells above F8, this is the part of the formula to change. Assuming empty cells above F8 I'd try this =OFFSET(Sheet2!A1,COUNTA(Sheet2!F:F)+7,5) Catharine (aka WebGenii)...
  2. WebGenii

    Excel Cell Referencing

    Try using the OFFSET function in combination with COUNTA a sample formula would look like this. =OFFSET(Sheet2!A1,COUNTA(Sheet2!F:F)-1,5)

Part and Inventory Search

Back
Top