Forum Discussion
Solved
Date Update automatically
Hi Want to replace the Date with a new date which is available in the next sheet but the condition is Every name is different each cell if the name is the same then check the date if the date is the ...
It is possble to use Power Query in Excel.
Merage to sheets by name by all outer
Use if then else to pick up the updated cell.
After merge, you will combine 2 sheet in one.
If in older sheet column A and new sheet column B have the data you need to compare,
You just need to add a custom column in PQ with fomular below
if [B]=null
then [A]
else if [A]=[B]
then [A]
else [B]
It is possble to use Power Query in Excel.
Merage to sheets by name by all outer
Use if then else to pick up the updated cell.
After merge, you will combine 2 sheet in one.
If in older sheet column A and new sheet column B have the data you need to compare,
You just need to add a custom column in PQ with fomular below
if [B]=null
then [A]
else if [A]=[B]
then [A]
else [B]
- Thank you for your Support I will try And let you know.
