Hello All,
I need help on getting Latest date required for latest change in 2
different categories
In below data for supplier 190007, I should get Aug'11 for C category &
Oct'14 for M category which is showing latest updates in resp category. Pl
support
Supplier Number YYYY C M Grand Total 0000009477 Jun11 407,349
407,349 0000190007 Mar11 37,607,833 37,607,833 May11
- - Aug11 (21,790,291) (21,790,291)
Nov11 9,568,354 9,568,354 Aug12 10,062,480
10,062,480 Dec12 11,667,650 11,667,650 Aug13 7,782,628
7,782,628 Oct14 6,742,988 6,742,988 0000190105 Nov12
1,876,174 1,876,174 May13 1,272,822 1,272,822
0000190129 Feb11 972,000 972,000 Mar11
25,854,000 25,854,000 Feb12 4,624,695 4,624,695
May15 1,559,421 1,559,421 Nov11 26,592,731
26,592,731 Aug12 9,787,700 9,787,700 Feb13
7,529,000 7,529,000 Feb14 8,246,695 8,246,695
Aug14 8,382,779 8,382,779 Feb15 1,475,949
1,475,949 0000190137 Jan11 4,961,772 4,961,772
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
