This seems way too complicated for me so I need a little help.
I have two separate tables that have data copied and pasted into them from different sources.
The first table (MONITORDATA) has a lot of outputs, date, time, memory number, and product number. The second table (HISTORY) has Date Time (as one entry), contents, memory number, ID, and Mode.
Is there anyway I could highlight an entire row in MONITORDATA when the HISTORY[MODE] = "ALM" BUT, only if HISTORY[MEMORY] = MONITOR DATA[MEMORY, the times are also equal. The time is what I'm really having trouble with because it also has a date in the same cell.
I was thinking that maybe I could copy the contents of HISTORY[DATE TIME] to another column but strip the date from the value.
I would really love some help on this. Thank you!
Bookmarks