|
|
#3
12-04-2018, 06:36 AM
|
|||
|
|||
A good example why it is better not to store composite info in table. When you have separate columns for fore- and last names, you always can easily calculate full name, and you don't need to have complex formulas whenever you need some part on this full name instead.
In added file are formulas for case when name parts are on separate columns, and also when full name is used instead. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Filter or Lookup Formula to Organize Keywords
|
MKTGCLOUD | Excel | 8 | 11-28-2018 07:35 PM |
|
Change "lastname, firstname" to "firstname lastname" Find & replace
|
delgesu | Word | 1 | 03-11-2018 10:20 PM |
| Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
| Formula help please (lookup across multiple sheets) | froggybsb03 | Excel | 2 | 03-16-2017 02:16 AM |
|
lookup or filter data, update it and save it
|
fre_ | Excel Programming | 3 | 06-06-2016 08:54 PM |
Windows 8 
Office 2016
Threaded Mode