ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I have two files where I use for data. the data could reside in either file but never both. All I am looking for is a way or formula to tell me which file was used for my data. see below for example:
File 1: C:\Users\M\Desktop\Current MV stocks e.csv
File 2: C:\Users\M\Desktop\Current MV stocks T.csv
Column B is used for the finding formula. and Column N is where I would like to place the formula. if file 1 say file 1 and if file 2 say file 2. Column E is where I used the data. Thanks in advance!
File 1: C:\Users\M\Desktop\Current MV stocks e.csv
File 2: C:\Users\M\Desktop\Current MV stocks T.csv
Column B is used for the finding formula. and Column N is where I would like to place the formula. if file 1 say file 1 and if file 2 say file 2. Column E is where I used the data. Thanks in advance!
Book1 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Company | Symbol | Date of Purchase | Industry | Current Market Value | % of Portfolio | Cost | Unrealized Gain/Loss | Dividends YTD | ROI | LT or ST? | Formula needed | ||||
2 | XXXXXX | AAA | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | |||||
3 | XXXXXX | BBB | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | |||||
4 | XXXXXX | CCC | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | |||||
5 | XXXXXX | DDD | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | |||||
6 | XXXXXX | EEE | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | XXXXXX | |||||
Sheet1 |