critera

  1. M

    Search by textbox and criteria combobox and show in listbox

    Hello, good day everyone, I want to search based on the combobox as (search column) and textbox in sheet 1. How is this possible? ABCDEFGH1no.Nameidsexagedate of birthIQ TestMeaning of Name214Ani4935426663female2231/10/199998Ornament, Beautiful, Variant of Anne /...
  2. C

    Index Match across worksheets with criteria

    Hi All, Apologies if the title doesn't explain my query best, but I have data in separate worksheets and want to create a search filter with set criteria. Cell A2 is a data validation list to select the desired test. Cell B2 is the select the mathematical operator for greater or less than. Cell...
  3. K

    Filter in multiple areas

    Hello to all, Im strugling to solve this for a week now. I would like to create filter something like: =FILTER(I4:I97,(J23:J40="PN")+(J42:J59="PN")+(J61:J78="N")+(J80:J97="N"),"") but always with error. This is just an example, I already tryed multiple variants of this, but still with some...
  4. Y

    Macro code to autofilter & select dynamic data.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
  5. G

    need macro help to concatenate columns based on criteria

    Dear All, Need help to create a macro which will give me the output as given in Column I (Output). Column C, D, E, F needs to be concatenated and then the macro needs to provide data for each "Supervisor Email" together in a single cell in Column I. The number of rows in the data keep changing...
  6. K

    Multiple Dates (columns) are within range

    Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...
  7. R

    I want The lowest (minimum) and the highest (maximum) amount of total sales with criteria

    hello guys , i have a data that include this columns , and i want to know the lowest and highest sale for city 1 in these 5 month , that's mean formula must sum the sale of city 1 for 5 month Individually and show the lowest sale ABCDEFGH1monthcity codesalecity codeThe lowest amount of total...
  8. tourless

    Count Unique Text based on criteria

    Hi Folks. Working with about 1000 rows of data, I have numeric values in column D not sorted but recurring at random intervals. Column A contains names. Those names can and will be repeated. I'm looking for a way to say if the cell in column D is equal to 000415 then count the unique text...
  9. W

    Rank by group (3 columns)

    Hi all, I have read a lot of the forums to related about rank by multiple criteria, but I still not work for me. I would like to rank by value sales (column F) based on Shop, Category and Period. I have already input the expected rank in last column, please kindly help me to solve this...
  10. J

    Adding a range based on criteria

    I'm having some trouble coming up with a code that will work for this. Any help would be greatly appreciated!! I need something like.. If the cell in column D shows "Setup" add the cells in column L, going up, but stop adding when the cell in column D shows "Setup" again. Then put that total...
  11. M

    Sum/extract distinct, filter values of column A to K

    Hi, Required a formula help to extract distinct filtered values of column A to C and for the outcome distinct values return a sum values of Hours and Amount situated at column D to K, as based on data set contains a columns A to K. Thanks...
  12. Z

    help needed with formula

    hi, i have this table which consist all the transaction happen in the month(Mytransaction). in another table(Summary), i would like to do a summary based on the transaction table. in one of the cells is to input the latest balance of the account so the problem is that I want a formula to detect...
  13. G

    Paste value once

    I have this VBA, however, when I run it, it repeats until I get a runtime error. I am trying to get it to where it pastes the cell's value if it reaches over a text limit. The limit would be 20. This cell(A2) has a card scanned and pastes the values of the card in the cell, instead of clicking a...
  14. J

    VBA code to run a query where criteria equals a range of data

    I have a spreadsheet that I need to run a query on but only if a field is in a range of data. I want to paste in a list of stock numbers in a worksheet (starting in cell A2 going down) but only have the query return data for those stock numbers. The number of stock numbers will vary and others...
  15. V

    Detect if worksheet exist, and if it does ignore the rest of the script

    I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script. I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble... Of course this might not be the ideal way to...
  16. V

    Delete all sheets that meets my critera without prompt

    I'm looking for a script to delete any sheets that meets the following critera and without promtp: If sheets contains the text: "PrixMax" "6po" "Quote" Then deleted them Sheet name can be "PrixMax-250", "6po-Viny", "Quote-101018" Along with those sheets, my workbook contains a "Master" sheets...
  17. J

    Formula to rank invoices based on status and date

    HELLO, I ALREADY HAD SPEND TO MUCH TIME TRYING TO FIND THIS FORMULA FOR MY OWN, SO I DECIDED TO ELEVATE THIS TO THE EXPERTS. IM LOOKING FOR A FORMULA TO RANK INVOICES BASED ON STATUS AND DATE. <tbody> STATUS DATE RANK (must Be) RANK FORMULA PAID 31-JAN-2019 6 PAST DUE 28-FEB-2019 1...
  18. S

    VBA: to loop and copy/paste based on 2 criteria (similar to a Hlookup)

    I have a data set that has 200 rows with (let's say) 40 entries per row and each entry is divided by year (40 years worth of values). The entries are numbered 1 - 200. I would like to create a new dataset by entry number and make each yearly entry monthly depending on whatever year it...
  19. E

    Looking for a genius: Match Debits to Multiple Credits or vise versa

    Hello, I am trying to see if there is a way (I'm doubting whether this is even possible anymore) to highlight or mark items that can offset each other exactly given certain criteria (for this purpose Project and Fund Column B and C). For example: There could be 250, 250, 500 that would 0 out...
  20. T

    Pasting a Row Based on Column Criteria.

    Hello all, I have a worksheet, where in Column F, there are about 200 instances of a cell containing the text "EBITDA". I have used a macro to insert an extra row below each of these instances, however I'm looking to copy and past the contents (formulas & Format) of Row 31 so that it can be...

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