-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cba
-
K
Bulk Search Keywords and Return to Values
Hi pros, Could I please get your 2 cents on this? I have a set of data which contains some keywords that can be used as parameters to do some search, my idea is to use my keywords list to check if any of them are in the data list, is yes then return to a value. To be precise, if A2:A20 is...- Koala123
- Thread
- cba excel & formula payment search vba & excel
- Replies: 5
- Forum: Excel Questions
-
P
Countif/s
Hi im being dumb, Im trying to do a count if where if the value in range a2:a239 is equal to l26 (separate tab) then I want to know if the value in raneg i2;i239 is greater than f2:f239 count that. tried : but not working ( i do mean 329 cba to edit all above lol) COUNTIFS('Contract...- PGD15
- Thread
- cba count f2f239 summary$l$26 working
- Replies: 2
- Forum: Excel Questions
-
B
Autofill down from a variable cell
I'd like to create a template that can copy and paste data, while autofilling data next to it. The data I have would be pasted in random amounts, so I have no set Range to reference. I have part of some code that lets me paste down to the last row of another column, but the code I have won't...- BillyH
- Thread
- autofill cba lastrow
- Replies: 3
- Forum: Excel Questions
