josh

  1. Dazzawm

    Formula To Randomise Names

    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...
  2. M

    Subtracting from a total and show remaning

    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. ¤...
  3. D

    excelisfun array multiple lookup in one cell

    :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...
  4. J

    Averaging a range of numbers using the indirect function

    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
  5. S

    How do I get a vlook-up to return a value with the correct formatting?

    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...
  6. C

    Lookup using multiple criteria with column/row defined tables

    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...
  7. J

    Missing Numbers from a Custom Sequence According to Multiple Unique Identiers

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top