josh

I have a list of names layed out like below. I need a formula please to randomise them so no name is next to each other in the list. Thanks. <colgroup><col></colgroup><tbody> Louis Pearce Louis Pearce Louis Pearce Louis Pearce Anthony Ray Clive Kelly Clive Kelly Clive Kelly...

Hello, Ok so what I am trying to do is, I have a total of 500. And I have different accounts I want the 500 to come out of like for example: (A1) (B1) (C1) Dan. 100. ¤ Bob. 50. ¤ Mark. 50. ¤ John. 25. ¤ Alex. 200. ¤...

:banghead::banghead::banghead: I came across an excelisfun video a while ago in which a lookup was used that showed all values in one cell. VERY similar to the textjoin(), but it worked in 2010. ....and of course, I can't find it, nor do I remember what I searched when I stumbled upon it...

I currently have the equation: =average('Enter Data Here'!C3:C33) in the second sheet. How can I apply the "indirect" function to this equation in a format that will allow me to drag the equation down the page? Thanks -Josh

Lets say I have in column A, fruit names: Apple Banana Orange and in column B, I have price discounts for the corresponding fruit: $0.20 5% $1.00 If I were to do a look-up in column C, those prices end up being: 0.2 .05 1 Is there a way for me to keep the formatting? I can't format the...

Greetings and salutations oh great gurus of all things EXCEL!! I need a formula to return a person's name with from the below example after using "CATEGORY" and "DIVISION" to quantify. For instance, if I enter BEER and FLBU, I would expect it to return Paul Oderio as the name. Any suggestions...

I am using Excel 10. If I have multiple reps that have scheduled visits, and the scheduled visits I want to track are identified with the numbers 2-51. How do I identify the missing visits according to the rep? I have found a few great VBAs for the missing numbers, have not found a solution...