Search results

Thanks everyone for responding! Thanks DaveTurton and SirJB I'll try your approaches, thanks also to Hui, jeffrey and everyone who jumped in.

Hi everyone! Here's a question I've had for some time. It's mostly about the visuals of excel reports, but I'd love to have a way for excel to show something- a clock, a pop up, anything- that indicates the progression of a macro as it's running. I've looked online and found pretty cool...

Worked like a charm! Thanks!

Hi everyone, I'm having some trouble with something that's really simple and can't get it to work. Hopefully someone will be able to shed some light. Basically, I need VBA to compare two ranges (of the same lenght) and, if they are equal, do something. Like this: If...

Yess that did it!!!! You rock it's been quite a headache for me. Thankssss

Yupppp noticed it was a randbetween so I pasted values. I tried with that same set of data you uploaded as well as a new one and it still leaves a few ocurrences where the criteria matches undeleted. Check in that same file and you'll see that some rows with "HOUSE" remain (not all, but a...

I used the new code and I don't know why it skips some rows. I mean, it deletes most of the rows where "House" appears, but it also leaves a few of them. Do you know why this could be happening? Thanks!

Thanks SirJB! Actually I need it to delete the whole row where the criteria appears (House).

Thanks! Narayank, I've tried to adapt your code to delete instead of clearing contents, and it deletes some rows but not all. Is there a way of making it delete instead of clearing contents? If it's not possible to delete between ranges of columns, how could I get it to delete the whole...

That's perfect and real simple as well. Thanks!

HI SirJB! I've tried it but it appears to be counting, instead of summing. It would need to actually sum in column K, whenever the criteria appears in range A1:K19, and whenever the criteria is repeated in a row, it should only sum once for that row (and not every time the criteria appears)...

I've uploaded here: https://docs.google.com/file/d/0B9nov_b3A5SvOEItMG82QlhQREE/edit?usp=sharing As you'll see the criteria (House) can be in multiple columns, and also appear many times in the same row. In this case, I'd need to only sum once (and not repeat by the amount of times it...

Hello everyone I have the following scenario: I need to make a SUMIF, where the criteria might be repeated several times in the criteria range, and the criteria range is made up of multiple columns, let's say A1:N200. So, it would be (if this was possible) like...

Hi Sajan, could you help me understand the formula? Because I need to do the same, but instead of a COUNTIF, a SUMIF, always against the same criteria ("car" in the example). The range to sum would be range2 on the example. I don't fully understand the MMULT but I see it looks like it's...

That works perfectly Narayank! Thanks!!

Thanks! you are right, Im clearing contents. So how can I get it to delete the rows where that cell is, yet only between columns A and N? Deleting/clearing contents any will do actually.

Hi! I'm having some trouble with this code. I want vba to delete every row where a cell meets a certain criteria (let's say "House"). But not the entire row, only between columns "A" and "N" for example. This is what I managed to conquer so far, but that only deletes the specific cell: Sub...

Nailed it!! Thanks Sajan. And thanks Faseeh as well! Great weekend everyone!

One question though, let's say that in a row i have the first criteria appearing several times, and it also meets the criteria from the 2nd condition as proposed, the count will be multiplied. It will return the amount of times both criterias appear, instead of a single "1" as a countifs would...

Works like a charm!!!! Thanks Hui!

Hi everyone! I'm trying to do the following, maybe someone can help. I need to countifs using a single criteria, and the criteria range is made of multiple columns. For example, if it were possible, it would be something like this: =COUNTIFS(A:I,O5,J:J,O4) You'll notice that the 1st...

It's perfect Narayan, thanks (yet again). Yes it worked fine in other workbooks, I don't understand why. I'll look into your code it's probably smarter. Thanks a lot.

Hi! I'm having a hard time with a multi-select listbox I'm using on a particular file. Here's the link: https://docs.google.com/file/d/0B9nov_b3A5SvcDAxTWhaaUlRb2s/edit?usp=sharing The listbox is in the sheet "C2". The code on the multi-select works OK everywhere except on this file...

It look right, make sure you are locking C7 ($C$7) Keep in mind that whenever C7 = 0, it will return FALSE.

Both were perfect! That was awesome thanks a lot. It really helps with my education in VBA.