New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

recently increased amount, which is increased and which date

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

recently increased amount, which is increased and which date

Postby bharath » Tue Jul 05, 2016 12:56 am

hi

I have some values in b5:b14 currency format, the same way C5:c14 date format. I need recently increased amount, which is increased and which date.
so please suggest which formula I can use for the scenarios.
Example 1 :
amount date
100 01/01/16
50 02/02/16
100 03/02/16
100 04/01/16

here increased value is 100 with date 03/02/16, this values I need in C4 and c5.

amount date
100 01/01/16
100 02/02/16
100 03/02/16
100 04/01/16

here there is no any changes in amount so it should be 100 with 01/01/16 in C4 and c5.
  • 0

bharath
Rookie
 
Posts: 1
Joined: Jul 5, 2016
Reputation: 0
Excel Version: 2011

Re: recently increased amount, which is increased and which date

Postby Beamer » Sat Sep 03, 2016 12:17 am

Hi bharath, I'm not familiar with them, but I believe a pivot table is what you want. Just click on date and all the data will be sorted with the most recent changes at the top.
  • 0

Beamer
Excel Junkie
 
Posts: 217
Joined: Oct 3, 2014
Location: New South Wales, Australia
Reputation: 31
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 79 guests