criterias

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...

Greetings colleagues ... I`m a beginner in VBA. Can you help me? THE PROBLEM: My ListBox, when add more registers, it adds on top of the registers that were already added, instead of inserting in the lines below. HOW IT WORKS ON USERFORM: TextBox1 to insert a number; TextBox2 to enter a...

Hi, below is a partial formula. How can I count the number of AND criteria's that are met? (AND(CFW$16=2,CFW48=1),AND(CUI$16=2,CUI48=1),AND(DIU$16=2,DIU48=1)) I just need a 1 for one AND criteria, 2 for two AND criteria's, and 3 for three AND criteria's. Thank you, David

I have a data set, say 3 columns with an infinite number of rows. For the first column I'll put in names, second would be left handed or right handed, then third would be age. Now I'd use 2 cells, first which will contain a value of a name as first criteria, and the other will contain a value...

I require some help with the highlighted part of the formula as shown in the link below. I need it to return the value in J2 if the two criterias given matches. if not, contunie with the rest of the fomula. I keep getting a #value error. The criteria 1 is for the date in B2 to exist in the...

Hi all, Here is my post on excelforum: https://www.excelforum.com/excel-programming-vba-macros/1265119-copy-data-from-tables-into-other-tables-using-criteria-and-vba-with-example.html#post5068295 I have explained it in much detail there, and there is an example workbook uploaded there as well...

Hi All In my head I thought this would be pretty straight forward, but it quickly became apparent that it's not! What i have is a very big accident log, each row represents a accident entry and has a vast amount of information where i would like to extract certain information into a separate...

Hello, To make a long story short I've upload a excel sheet as example of my requesting. I'm looking for a way to get the sum of expenses based on multiple criterias. https://www.sendspace.com/file/2ibp7m ** the original file has a large amount of rows and with more arguments, so the attached...

In a SumIfs formula (Ifs not If) how many criteria's can you have? =SUMIFS(K$8:K25,$P$8:$P25,$Q25,$Q$8:$Q25,$R25,$R$8:$R25,$S25,$S$8:$S25,$T25) Example this one has 4

Hello, I have an Excel document where cell F35 sums up the total from cells F25:F34. Based on the result, I'm trying to, in cell F36, have a different value based on the following criterias: If the value of F35 is 0, I wish to have 0 in cell F36 If the value of F35 is 1, I wish to have 45 in...

Hello I am trying to create some lookups with multiple criterias see the links for screenshots of what I am trying to do. https://photos.app.goo.gl/mAuxs438hFUOjQZw1 https://photos.app.goo.gl/C9em194jvajqCEfy2

Hello everyone! I want to create a very user-friendly interface on excel, which allows the user to filter a table as an automatic filter or slicer would do. In order to do it, I tried to use VBA and some macros. I am stuck for few days now, and begin to get desperate :(... That is why I am...

Merry Christmas, everybody. I have a sheet with about 50 countifs. Theese countifs contain 7-8 criterias. 6-7 of theese criterias are identical. Now I want to add another criteria. The way I do it today, it means alot of copy-paste. So, is it possible to write each of the criterias in a cell...

Hy, I have 5 pivot table on a sheet (PIVOT). I need to filter the data based a list of criterias on another sheet (WORK2) The list contains the criterias i need to unselect in all the pivot tables (.PivotItems.Visible = False) Can You help me in this case? Thank You Guys! :)

hi there, i feel like this is simple but having trouble figuring it out. i basically want to pull data from one sheet to another where the data has to meet multiple criterias. the criterias are week#, year, and business unit if all of those criterias match on both sheets i want a return of...

Hi All, I need some help, I can manage to delete rows dynamically.. but idk on how to delete table dynamically based on criterias with Selection.ListObject.ListRows(x).Delete command example below, how to delete "Bread" - type only using VBA? thanks for the help guys! much appreciate

Hi all, Just a quick Excel question on sumproduct functions. Are there certain cases where you use "," verses "*" between criterias? Does it matter?

Hi, I have the following formula which is returning a #REF! error; =INDEX('Paddock-Plan-Crops'!$V$17:$V$67,MATCH(S$7,'Paddock-Plan-Crops'!$G$17:$G$67,0),MATCH(S$4,'Paddock-Plan-Crops'!$Y$17:$Y$67,0)) Basically I need the formula to return the value from column V only when both of the Match...

Running Windows 10 Microsoft Office Home and Student 2010 Excel In the "adjusted stone + setting" column, I have the following formula in that column.

Hi Guys, I cant seem to get this formula the way I need it. =SUMIF(O:O;"<>INTERN";J:J) So what I want to do is to add more criterias in addition to "<>INTERN"... probably real easy, but onfortunately Im not that Excel savvy. Can anyone help? -Nic