![]() |
#10
|
|||
|
|||
![]()
Just one last thing.
The formulas in Summary!E3:E6 are array formulas so please be aware that when entering such a formula you must hold down Ctrl and Shift before pressing Enter (instead of just pressing Enter). If you do it correctly Excel will put brackets around the formula {}. Don't try to enter these brackets manually. When you have entered one array formula correctly you can copy it to other cells as you normally do. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
Index and Match functions | aman.chauhan | Excel | 1 | 06-18-2016 02:09 AM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
![]() |
jackzha | Excel | 5 | 12-03-2014 12:43 PM |
![]() |
david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |