care

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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