redfishman
New Member
- Joined
- Jul 25, 2008
- Messages
- 9
I have two data files. In one the time is showing in the column "Time". In the other file, the column "Time" is there but there is no time shown. When the transfer from one system to the other took place, the time did not advance to the other data file or was probably deleted by mistake.
I have both files on my system. The incident # of the original file (A) and the incident # of the cleaned original file (B) do not match exactly. Some incident #'s on (B) have been deleted. But the ones remaining in (B) need the time place in each row, where the incident # in (A) matches incident # in (B).
Can you wirte a formula for this? I am not a techy but can follow directions.
I am using Windows 10, Excel 2016
Thank you
I have both files on my system. The incident # of the original file (A) and the incident # of the cleaned original file (B) do not match exactly. Some incident #'s on (B) have been deleted. But the ones remaining in (B) need the time place in each row, where the incident # in (A) matches incident # in (B).
Can you wirte a formula for this? I am not a techy but can follow directions.
I am using Windows 10, Excel 2016
Thank you