Jan 10 2022 06:03 AM
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 same the leave as it or if it is different then update the new date from next sheet.
Jan 17 2022 06:01 PM
SolutionIt 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]
Jan 18 2022 04:49 AM
Jan 17 2022 06:01 PM
SolutionIt 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]