nm1

Hello All, I am working with a userform and need to have a named range value returned as a format number. Currently my named range ("PrgB") returns the value = 51.515151 I need to have this format as a 2 digit number = 51 but cant seem to get this done. Any help is appreciated! my partial...

folks, I need to remove the title "Dr" from a list of names prior to publishing. Not all names have this title. I can find the substring within my specific range with pos = InStr(nm1, "Dr ") where nm1 contains a name. nm1 refers to the cell C9 on my spreadsheet. if nm1 does not contain the...

Hi Guys, I have data which I would like to automate for my reporting so I have raw data so firstyl i would like to group by dates if ship name is the same and if "Secondary Mode" is Breakdown also I want to group by "Description" if its the same So If Ship nm1 had breakdown in january from...

I have the following columns of data and would like to have a formula that returns the name whenever one of the corresponding fields matches a certain value. 1/7/2018 1/8/2018 1/9/2018 1/10/2018 1/11/2018 1/12/2018 1/13/2018 Person Sunday Monday Tuesday Wednesday Thursday Friday Saturday...