Ageing days

General Excel Questions & Answers

Last Post by Philip Treacy 3 years ago

2 Posts

2 Users

0 Reactions

117 Views

RSS

Md Saliha

(@navsal66)

Posts: 108

Estimable Member

Topic starter

Hello Every one

I have attached Ageing days report can any one help me to update formula for E column(Status) & F column (Remarks) which is i always updating manually

based on that Aging in days

regards/Saliha

Posted : 06/02/2022 6:37 am

Philip Treacy

(@philipt)

Posts: 1629

Member Admin

Hi Saliha,

You can use an approximate match VLOOKUP for this - see attached file.

regards

Phil

Posted : 06/02/2022 10:17 pm

26 Forums
7,236 Topics
31.8 K Posts
41 Online
35.2 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Ageing days

Super Globals

Options and Features