care

  1. J

    Extract multiple matches into separate rows

    Hello world. I'm having an issue where I have and index and match with multiple return values but running into problems. Here's my setup: A B C D E 1 2 10A 3 [first] 4 [2nd] 5 [3rd] 6 [4th] =IFERROR(INDEX('BETA Care Plans'!$B$1:$B$215,SMALL(IF('BETA Care...
  2. B

    is there a way to make a pivot table show only negative values *in all fields* ?

    I have a pivot table where I'm trying to find all the losses. So I'm seeing all the values, where 80% are positive, but I only care about the negative ones. Is there a way to show only negative values? Please note, this isn't just in the grand total column - I want this in the entire grid. For...
  3. B

    Filter out row when names appear only once

    I have a large list of names and when names appear only once I want to filter out the row they appear in. There is other data in the row with the names that will be filtered after the names that appear only once are out. The document length can vary, not sure if that matters. I thought I could...
  4. N

    Format cells for 2 digit places...

    Good Evening.... I have a column with dollar amounts, as such, for example " $21.85. Any amount with a zero at the end will not show when I do a drop down list at data validation. For example...$18.50, will show as "18.5". I do not care about the $ sign, but I need that zero at the end. I have...
  5. C

    Power Query - unpivot quantity and values

    Hi All, I have the below data set, and the problem is that quantity and value is dumped by columns, and there are around 50 columns of quantity and value by each store. How can I arrange this in a tabular format and summarize by store / category with quantity and value. I have to select each...
  6. Hawkmek

    Not sure how to title this, please take a peek.

    Had such good luck this morning I thought I would try again before Happy Hour. Data will be sorted by column A so all reds, blues, greens, etc will be together. Formulas will be in Column C Scan Column B for 'target'. When target found populate Column C with target until value in A changes...
  7. A

    Search occurrences in a range, and if not found skip their procedure

    Hello all, My code starts with a range that the code filters and there supposed to be left 3 values after filtering. Each value has its own sub-procedure. The range is column "B". I would like the first sub, the one that filters, to check if what is left after filtering is actually there. If...
  8. M

    Remove gaps in lines of text ?

    How do I remove the 'Gaps' in Col B of my Excel Sheet ? Screenshot Link https://ibb.co/mU1Udy Anyone care to share Excel Function or Code, instead of doing it manually ? Thanks in Advance.
  9. G

    IF stament wih date ranges and between

    Hello anybody can help me solve a formula to check if the inv date fall between a promo allowance and if so get that promo allowance % and multiply by case, below is the data incentive table that im referring, I will like to bring the percentage...
  10. R

    Can a cell value name a tab?

    I have about 150 files each is almost identical with a few naming convention changes. It will streamline my work process if I can enter a value in a cell and have it name the tab at the bottom of the sheet. This way, I only need to enter the value in one cell for each file and it will take care...
  11. T

    How do I collate information across multiple sites

    Hi all, A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites <tbody> Name Job Title & Team </tbody>...
  12. B

    Merge Rows, if

    Hi All, I have an excel sheet with two Columns, Organization Name and Type. I would like to merge all the types for a particular organization into one single row. Example <tbody> <tbody> 3Bridges Community Before School Care, After School Care and Vacation Care </tbody> <tbody>...
  13. B

    Autofill with VBA

    Hey all. I am using the following code to attempt to autofill a formula to the last row as defined. I am receiving a 400 error and was wondering if anyone has a solution. Thanks Dim lastRow As Long lastRow = Range("L" & Rows.Count).End(xlUp).Row Sheets("FYXX-XX Charity Care...
  14. S

    Highlight Some Duplicates but Not Others

    I'm failing at trying to come up with a statement that will only highlight the numerical values that are duplicates in a single column rather. i.e.: <colgroup><col></colgroup><tbody> 95210452 95212176 95212176 95214475 95219924 95219924 97146350 95228184 95230612 95234230...
  15. M

    LOOKUP with multiple matches, and how to use criteria to return single value

    Hello. I am a first time poster here. I am used to using lookups, but stuck with moving to a situation where I have multiple matches and want to apply a criteria to return a single value I am interested in. The data below show some inspection data for care home quality, which include some...
  16. D

    Trying to get Excel to send a sheet as a PDF

    Hiya Peeps, I wonder if someone can help me with this. I am trying to get the code to select the right data via autofilter, then email the sheet as a PDF. I have the following code: Sub Sort1() ' ActiveSheet.Range("$AB$4:$AB$350").AutoFilter Field:=1, Criteria1:=Array( _ "Care...
  17. R

    Questions with PERSONAL.XLSB

    My company want to upgrade CPU, will that affect the macros that stored in PERSONAL.XLSB ? Will I have to re-record the macro again ? If there is upgrade of Excel version, will there be any compatibility issues ? What other things I need to take care for the changes ? Hopefully, the...

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