variations

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

I'm struggling to use a wildcard with an if statement. my formula is "=IF(OR(BZ1="99",BZ1="99"&"*"),"True","False")" I need it to check the cell and if it has either 99 or variations of 99- then be true.

=COUNTIF(INDIRECT("$AP19:$AP$9999"&$A$1),"9") =SUMIF(INDIRECT("$AP$19:$AP$9999"&$A$1),"9",$BD$19:$BD$9999) I am using these formulas successfully but now I want to change the 9 to the range of 1:9 I tried several variations of the above, but to no avail. thanks Ironsides

Hi group, I am working on a piece of code that seemed to work in the past and now I am getting a weird error? "Error 450: Wrong number of arguments or invalid property assignment". I have marked the line with the error below. I have tried several variations of the line to see if I could...

Hi - I have been using on a Query for a while where the date(in text) is 23/03/2012. Unfortunately a process has changed the date (in text) to 23/Jun/2018. Therefore when I use my Query Like "*06/2018" it brings nothing back I have tried all kinds of variations (trying to return all entries...

Hi, I'm trying to count the number of times the letter "O" appears in any column where the first row =1, then 2, and so on: I've been playing around with =countifs() and variations of nested =countif() without luck. Does anyone have any tips to help me with this please? Cheers, Pete

What LOOKUP formula would I use to look at column B and tell me if there's a matching number in column E. B is not in numerical order but E is. I have tried several different variations of different LOOKUP formulas but none of them seem to work and I can't figure out what I'm doing wrong.

Hi Hope you can help. I need to get the % change between 2 numbers. Here are all the variations possible 1 2 1/2-1 2 1 2/1-1 1 -2 1/2-1*-1 -2 1 -2/1-1 -1 -2 -2/-1-1 -2 -1 -1/-2-1 Now these are the variations and lets assume the first number is in...

Sheet1, column A contains the following data: BOFL BOF Locations Building our Future Locations These are all variations of the same same value, just written in slightly different ways. In Sheet 2, Column A, I have listed all of the variations (I may need to add more variations in future). I...

I have a (long) formula that is functioning quite well. However, I now need to be able to pick up any variations of "na" that I could potentially run across (NA, N/A, etc.). In other words, I would like to basically pick up a wildcard value such as "n*". I understand that "Like" is probably...

have tried log and ln with variations of Application.WorksheetFunction. all give same err or

Hello all, I've heard this is a very helpful group of individuals and hopefully you can help me solve my issue. Also, sorry if this is answered somewhere, I have hard time searching this situation. I currently run a report each day containing training data for multiple companies. The issue...

Hi all! Love the forum and always get my questions answered through a search, but cannot seem to find an exact answer for what I'm looking for this time. I want to do a sumproduct of the values in columns A*B only if there is text in column C (not blank). I've tried a bunch of variations but I...

Hiya peeps, So I'm trying to work something out. In column A I have staff names. In row 1 I have the days of the week. Column B is titled Monday Column C is titled Tuesday and so on. So say for example in cell B1, I have written down 88 (this means that staff 1, is working 8-8 on Monday. I've...

Hi All, I'm working with the following code: Sub Macro11() ' ' ' Worksheets("REPORT").Select Worksheets("REPORT").Range("A1:L47").Select End Sub Does anyone know how to combine these terms so I have one line? For example, I've tried variations of this code below, but I'm...

Hi, I am trying to find a way to identify and display the combinations of 1,2,3,4,5,6 using 2 numbers, 3 numbers all the way up to 6 numbers, i.e. 2 numbers = 1,2 - 1,3 - 1,4 - 2,3 etc 3 numbers = 1,2,3 - 1,2,4 - 1,2,5 etc 6 numbers = 1,2,3,4,5,6 (I do not need 6,5,4,3,2,1 or any other...