# tompols 26

Contributor
Registration date
July 28, 2004
Contributions
24
Gender
Male
Birthdate
May 15, 1980
Location
grenoble, FRANCE
Signature
On entend par une belle solution, la solution simple et facile d'un problème difficile et compliqué

## Copy row if a range of column matches a value [Solved]

Could you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But in my case, I would like to copy the entire row if a range of column (for ex: B via Z) contains the value "1". It would even be better, if the user could input a number/string and then if th... Read more

## Copy row if a range of column matches a value [Solved]

Could you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But in my case, I would like to copy the entire row if a range of column (for ex: B via Z) contains the value "1". It would even be better, if the user could input a number/string and then if th... Read more

## countif with and function

Hello, I am trying to count cells in a column if they are greater than 60 and less than 29. How can this be done with a countif and function? Thanks! Julie

1
Thanks

## If X is between A and B, then C [Solved]

Hello, Worksheet 1 Jan 10 Jan 12 Jan 12 10am Jan 13 Jan 15 Jan 16 9am Worksheet 2 Jan 11 I'm having trouble coming up with a formula to put in [Worksheet 2 Column B] that would come up with "Jan 12 10am" for Jan 11. I tried =IF(AND(A1>='WORKSHEET 1'!A:A,A1 Read more