issued

  1. S

    Excel chart: group by month, cluster by department, stack by type

    I'm sure I've got some of the terminology wrong, but here's basically what I'm trying to do. I have a table of data with three fields I want to use in a chart: date issued, department, and type. What I'd like to end up with is months along the x-axis based on the date issued, a count of entries...
  2. J

    Doing an allocation in Excel

    I have another task in excel that I must perform that I hope you'll will be able to help me with. Once again I am allocating limited money however, this time I need to allocated the same to everyone in increments until the pool is exhausted. So its almost like dealing cards. For each round...
  3. J

    Lookup function

    How can I lookup the highest number in a range of cells and find out information associated with that number, if the number was issued on a specific date for instance how can I look up that date?
  4. T

    Combinations and Common Key

    I have found several threads creating all combinations of pairs within a list. I am having trouble with inserting an additional field to consider if the numbers are eligible to be paired. First column is a list of work orders (many instances). The second column is a list of items issued to...
  5. Z

    countif no match between two columns - single formula only

    Hi guys, need a bit of help on this one please. I have 3 columns of data: A - B - C a - a - Issued b - c - Issued c - c - Issued d - f - Issued e - a - Issued f - c - Active Column A has unqiue values. Column B has duplicates. Column C...
  6. C

    Help building button to move data from working cells to record keeping sheet

    Hey all, I have a workbook that is used to issue sets of 4 random GPS markers to ATV riders for an annual poker ride. When the riders return with the serial number from each marker they were issued, I need to cross reference with the database to confirm they have matching numbers. I have a...
  7. O

    VBA - Split String closest to 300 char with the delimiter fullstop

    Hi I need to split a string closest to 300 characters where the last character is a full stop...woah hope that makes sense :). The text keeps concatenating depending on the values in other cells for example: If Sheets("control").Range("B15").Value = "AS2124" Then letterString = letterString...
  8. S

    Need Help Building Excel Formula Concerning Days Overdue vs. Expected (with complications)

    I am building a quality assurance spreadsheet to track timeliness of document submissions. In Column A, I will list the date a document is expected to be issued. In Column B I will list either a date that the document was actually issued or a blank cell, representing a still outstanding...

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