-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
simplifying formulas
-
I
Need help simplifying array, max formula
I built a formula to retrieve a date from a list. {MAX(IF(AM2='POs Recpt Date '!A:A,'POs Recpt Date '!E:E)} <colgroup><col><col><col><col><col></colgroup><tbody> PO Value DC PO Vendor PO Date recvd $18,022.20 LIV 217550 XXX 1/0/1900 $19,050.00 LIV 217603 XXX 8/7/2015 $19,050.00...- ibesmond
- Thread
- array formula max function simplify formula vlookup
- Replies: 2
- Forum: Excel Questions
-
A
Cashier Spreadsheet Project: Problem #1 - Simplifying a Formula
Hello everyone :) I have recently acquired a small bar and decided that the Cashier Spreadsheet needed a rather major overhaul (business is too small to justify a POS system). I'm finding that the more time I spend on this, the more I think about the information that I would like to extract...- ackalbo
- Thread
- cashier
- Replies: 7
- Forum: Excel Questions
-
S
Simplifying formulas to increase speed of excel workbook
So I have a large excel workbook, with lots of heavy formulas, which have now stalled the workbook totally. Below are the top 1 in my mind that is very bulky and I need to reduce the repetition in to make them and the workbook quick. I am not adverse to adding in extra cells or splitting code...- SaraB802
- Thread
- index multiple countifs()
- Replies: 2
- Forum: Excel Questions
