rick

This site has helped me in years past and am stumped again. I have a spreadsheet of many rows. Column A is list of names Joe SMith Joe Smith Jane Doe Jane Doe Jane Doe Rick Smith Rick SMih I want to be able in column B to put in a sequence number so that both Joe Smiths end up sequence 1...

Hello everyone specially Rick, Last year you posted a macro, and I still trying to understand how it works. I know It is super powerful using Evaluate, but there is not so much info about how to use @ as you did in the macro. Can you please make a breakdown of your code: Sub PrefixAnApostophe()...

Hi Guys, I am trying to search through a CVS file that has a date/time stamp in column "A", I want to search for the current date and have it tell me know what row it starts in. The date / time stamp is "10/03/2018 08:22:24:510 " any guidance would be appreciated. Thanks Rick

I really appreciate you all taking your time to help people solve their problems, regardless of how difficult it is for you. It meant a lot to have the solid input I needed to make my spreadsheet happen. Thank you to Marcelo Branco & Rick Rothstein. You guys are Excel wizards who showed me some...

Hi all, I am currently using the formula =INDIRECT($C$2&"!A1") which works fine. what I now need is for the box below to be =INDIRECT($C$2&"!A2") and so on, down until A330 is this possible without manually changing the A1 to A2, A3, A4 and so on? Thanks Rick

Hi, can anyone tell me how to get the delta symbol to stop showing up as a capital D? Thanks, Rick

Hi, it's been a while for me so I need some help =IF(T3="208Y/120",208,OR(IF(T3="480Y/277",480,OR(IF(T3="240d/120",240))))) T3 is data validation with a list, the first part works correctly, ie. 208y/120 returns 208, the other 2 return "true" rather than 480 or 240. Thanks for your help, Rick