In a given set of data you want to find maximum or minimum number you can use the MAX + IF forumla,
Note : this is a CSE Formula, so please ensure you press Ctrl + Shift + Enter after typing this formula, instead of just pressing Enter.
Eg : A Vendor has many purchase records, you want to know when you purchased last
Say the records are this way
You want to know the last purchase details
The formula is
When you get an error in the tally, do the following
1) Go to Command prompt
2) Enter the text
a. First – Tally exe file path
b. Second – Data folder path
c. Third – Error Code ( code is there in the error msg )
3) Tally screen will appear - Don’t select the company
4) Ctrl+Alt+R – Rewrite command
5) It will delete the error
Every time you do this, don’t forget to thank me ;)
