charles

Is there a formulaic way to turn a list in two columns like this: <tbody> Albert 3 Bob 2 Charles 4 </tbody> into a new list in a single column like this (where the number of times that a name appears is dynamic based on the number next to it in the original data like above): Albert...

Hello, I have a column with various employees names. In the column next to that I have a variety of drop down options to choose from (day, night, etc.). What I would like to do is determine the number of options that fall under each person's name. For example, Charles is listed 50 times in...

hi all.. i know this has been done to death.. and even by me... however hoping for a solution... I have this table; <colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody> Client Staff Member a max b robert c charles d charles e charles f robert g robert...

Hi all! I need to create mailing labels with a list of data I've received. My lines have one, two, or three names. I tried to Convert Text to Columns, but there are just spaces separating the text. Here's an example from my list: Paul & Joan & Marjorie Roderick 75 E. Charles Street Long...

Hello All, I need a formula that is able to find to the last value (Excluding 0 and empty cells) and then divide it by the divider next to it. For example Allan's value must be -0.5 (row 8) because at the row 9 there is a 0. Brian's value must be -0.06667 because row 20 is zero and row 19 is...