Recent content by AmyT

Thanks for the tip.

Thanks! This worked. I saved the Formatted value as a text and appended it to the filename variable.

I am writing a collection to a file, and have chosen the Utilities- File Management and append to file. Is there a way to append a timestamp to the filename, so that multiple runs of the process will create different files, rather than appending it to the file. I tried concatenating the Now()...

Apologize for the confusion- I had earlier used 2 loops which is brutally inefficient, I prefer the solution recommended by you and will be updating the process. Thanks for the tip.

I have an excel spreadsheet with a number of columns,(userid, timestamp, ip address etc). I would like to extract only the unique userids to a collection. What is the best way to do so?

Thank you! I did this with 2 loops and comparing the values

I would like to compare 2 excel workbooks. Each workbook has a sheet and one column with user id. One workbook is the master file (say file A) and the other is a smaller file (say file B). I have read each of the workbooks in a collection each . I would like to identify all those users in file...