critera

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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