1. A

    Count consecutive numbers in Array

    Good day Experts..please help me with this I have 3 Columns with single digit numbers, I need to know how many times each digit repit consecutively.ex 345 367 410 123 012 306 here we can see 0 repit 1 times (rows 5, 6), 1 = 2(rows 3, 4 and 4, 5), 3 1 times (rows 1 and 2) please help with the...
  2. E

    Can't run multiple macros but alone they work

    Hi, I have a first macro that compile data using relative and absolute reference recording. My second macro consolidate data My third macro clean the table after the consolidation. I can run them fine alone but one after the other one its not working. Call doesnt work. Application wait...
  3. B

    Highlight rows with the same date and appointment time

    I am looking for a macro to highlight rows that have an appointment that occur on the same day at the same time. See table below for reference. 04/11/2022 11:00 AM 04/11/2022 11:00 AM 04/11/2022 10:00 AM 04/11/2022 9:00 AM 04/11/2022 8:00 AM 04/11/2022 10:00 AM 04/11/2022 8:00 AM
  4. Jyggalag

    Merge cells of emails into one cell - possible?

    Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...
  5. A

    How to sum values and remove duplicates rows

    Hi All, I'm trying to remove duplicates and sum values. I have table which is looks like that. item number client Date Quantity 167 C10000038 28/01/2022 00:00 3 600831 C10008630 27/01/2022 00:00 1 600831 C10008630 27/01/2022 00:00 48 600827 C10008630 28/01/2022 00:00 1 950114...
  6. A

    Two identical columns in pivot with different data

    Thanks in advance for any ideas you may have on my issue here: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...
  7. C

    Row by row comparison between 2 sheets - conditional formatting (changes/duplicates)

    Hey all! I'm trying to create a formula that can be used with conditional formatting to highlight changes, or duplicates, between 2 sheets, or 2 workbooks if that works better, on a row-by-row basis, for a week-by-week sales audit that we generate. I've tinkered with a bunch I've found online...
  8. S

    Rearrange Data to show Duplicates?

    Hi All, I need to rearrange data so that it shows duplicates rather than only unique values. For example, data that shows qualifications: Category Subcategory John Bob Rich Microsoft Excel X X Microsoft Word X X I want to change it to: Category Subcategory Name Microsoft...
  9. C

    Highlighting duplicates between 2 sheets that contain different orderings

    Hey all! Any help with this problem I'm bamboozling myself with would be hugely appreciated! So I have two different sheets I'm looking to compare and highlight duplicates of: Sheet 1 - Contains all current employee names in a "firstname*space*surname" format. It also contains a " [C]" to...
  10. M

    Query to return only the latest records record from linked table

    This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...
  11. A

    Creating duplicate cells based on another cell value

    First thread and hoping someone can help. As part of a reward and recognition incentive at work this month, I’m running a type of raffle. As we work from different sites around Australia, we’re keeping everything digital and recorded using Excel. I’m wanting to be able to create a vertical...
  12. K

    Pivot Table and Need to Ignore Second set of Data which is duplicate

    Hello, I know it's against rules to cross post but I haven't been able to find a solution to my problem anywhere else. So I'm posting it here again. Please don't delete it :) I'm trying to achieve something seems really difficult to, I asked about on some other forums including Microsoft...
  13. C

    Pivot Table repeating data

    I created a report that pulls raw data from QuickBooks that shows the payments we've received from customers over a certain time frame and gives the detail on the payment itself as well as the invoice the payment was applied to. When we receive separate payments on different days that are...
  14. AWM21

    Sum up active times for duplicate user entries. Isolate array and process times.

    Hello, I have a sheet of data in excel and I need to get the total minutes engaged per user. Most the users have a single row hosting their start and stop times. (Cell B1=UserName; B2=StartDateTime; B3=StopDateTime). I can get total number of minutes pretty easy from that, so no issue...
  15. A

    Find duplicate values and delete them in a single cell

    Hi guys I'm trying to find duplicate values (precisely duplicate email) in a single cell. I've got numerous of data that need to be clean by removing duplicates in a single cell. Then, i want it to be deleted directly. Appreciate if there is a formula/steps that can be use to solve this...
  16. D

    Excel Formula - Count duplicates in Column B per Name (Column A)?

    Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)l
  17. M

    Creating Duplicate Rows Out of pivot with two extra columns

    Hi everyone, I have a data set that is updated on regular basis by multiple users. Hence, the number of rows of this data set keeps on changing. However, the number of columns remain the same. The data set looks like following...
  18. M

    Function Not Working - Sort & Remove Duplicates by Creating New Array

    I am not well versed in VBA and have no idea where to start finding the issue here. I need to write a function that will take a 1 dimensional array as an input and spit out a new array with all the values sorted alphabetically and duplicates removed. This input "SourceList" column has text...
  19. M

    How many instances of a column with duplicated values

    Hello all, I have been struggling with this one and couldnt find answers on google! Though am sure the answer is fairly easy. So i have a list of duplicate values in a column as below. A A A B B C I need an excel formula (non vba) which results "3". Because we have only A, B and C regardless...
  20. moonsugar

    Could I have some help with this project? Repeat a set of cells down the length of a column

    Hi there! I've been using Google Sheets for some years, and have just come back to Excel for the first time since 2007. I've just spent perhaps the better part of an hour trying to search for what I'm trying to accomplish, with no luck. Somehow I've managed to do it before a few times, but I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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