New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Formula With Most Recent Dated Cell and Criteria Met

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Formula With Most Recent Dated Cell and Criteria Met

Postby mrinck » Tue Apr 05, 2016 10:22 am

Trying to Figure out how to show a certain cell for on 1 sheet on another sheet, but the cell needs to be the most recent entered row and meet criteria of another column.

So Column A is dated, Column B will have either an A or B as the criteria, Column E will also have criteria that will b a number sequence and I need to display the contents of the cell in Column J of that row on another active sheet. Hope that makes sense, everything but the formula does to me, lol.
  • 0

mrinck
Rookie
 
Posts: 3
Joined: Mar 2, 2016
Reputation: 0
Excel Version: excel 2013

Re: Formula With Most Recent Dated Cell and Criteria Met

Postby gebobs » Tue Apr 05, 2016 2:49 pm

Post what you have so far.
  • 0

gebobs
Regular
 
Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

Re: Formula With Most Recent Dated Cell and Criteria Met

Postby mrinck » Fri Apr 08, 2016 6:57 am

I dont have a formula started for it. I do not use excel trying to learn how to use the formulas as I go.
  • 0

mrinck
Rookie
 
Posts: 3
Joined: Mar 2, 2016
Reputation: 0
Excel Version: excel 2013


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 80 guests

cron