# Search:

Page 1 of 6 1

1. ## Thread: Copy range of cells to other sheet

Replies
3
Views
269

### Re: Copy range of cells to other sheet

assume we have this setup in sheet1:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...

Replies
7
Views
319

### Re: Countif

another solution would be using the CHOOSE Function.

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse;...

Replies
7
Views
319

### Re: Countif

another solution:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
4. ## Thread: Removing Duplicate Dates Keeping Column With Name

Replies
4
Views
286

### Re: Removing Duplicate Dates Keeping Column With Name

the VBA solution would be:

Option Explicit

Sub removedubs()

Dim Rng As Range: Set Rng = Sheet2.Range("b3:c12")
5. ## Thread: Removing Duplicate Dates Keeping Column With Name

Replies
4
Views
286

### Re: Removing Duplicate Dates Keeping Column With Name

I have a formula solution however it is not the best in term of performance as this formula is known to slow the processing speed on your workbook:

6. ## Thread: Associate a picture with a random number

Replies
3
Views
266

### Re: Associate a picture with a random number

bro

i showed in length how can you associate the pics with the random number generated by the...
7. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

Slot1=OFFSET(Sheet2!\$B\$2,Sheet1!\$C\$7-1,1)
Slot2=OFFSET(Sheet2!\$B\$2,Sheet1!\$D\$7-1,1)
Slot3=OFFSET(Sheet2!\$B\$2,Sheet1!\$E\$7-1,1)
Slot4=OFFSET(Sheet2!\$B\$2,Sheet1!\$F\$7-1,1)...
8. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

I think Howard is right.

this is do-able with formulas; i tried expanding the macro i gave you copy paste images into positions based on the random number generated but i failed.

the formula...
9. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

you know what ?

i guess i can do it; maybe. so stay tuned for an update.

well, if two days passed and you did not see any update; know that my brain went into freeze mode. only by then, open a...
10. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

that is interesting.

but i am still a noob that is beyond my skills

i guess you will have to wait for the geeks, scientists, nerds , Excel gods to visit your thread and shows us how this can be...
11. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

bro there was some error in my previous code :stickouttounge:

i fixed it

Sub randomgen()

Range(Range("c7"), Range("c7").End(xlToRight)).Clear
12. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

another take with macros on the same sheet structure i presented above:

Sub randomgen()

Range(Range("c7"), Range("c7").End(xlToRight)).Clear

Dim F As Integer: F = Range("d2").Value
Dim...
13. ## Thread: Macro to randomly choose numbers

Replies
13
Views
611

### Re: Macro to randomly choose numbers

without a macro i guess this works :

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...
14. ## Thread: Return Distinct Value based on Criteria in two other columns

Replies
6
Views
199

### Re: Return Distinct Value based on Criteria in two other columns

Your solution as always very fascinating for newbies like me :) took me an hour to crunch it.

one thing i still cannot comprehended is this:

when i analyze it in Evaluate...
15. ## Thread: add number to the middle of an existing number

Replies
6
Views
371

### Re: add number to the middle of an existing number

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
16. ## Thread: Need VBA to eliminate specific characters in cells

Replies
24
Views
957

### Re: Need VBA to eliminate specific characters in cells

Sub REMOVESTUFF()

Dim tempstring As String
For Each cell In Sheets("sheet1").UsedRange

tempstring = cell.Value
If Left(cell, 1) = ":" Or Left(cell, 1) = " " Or Left(cell, 1) = 0...
17. ## Thread: Conditional formatting on specifica date ranges

Replies
7
Views
335

### Re: Conditional formatting on specifica date ranges

rule 1: highlight with yellow

=AND((D\$3-TODAY())<=28,(D\$3-TODAY())>=0)

https://cdn.pbrd.co/images/2w7v02u0.png

rule 2 : - i did not understand it
18. ## Thread: Find the Last Row and Column with contents

Replies
7
Views
757

### Re: Find the Last Row and Column with contents

if this is my sheet content:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...

Replies
11
Views
464

### Re: formula help

why the "--" ? can you explain why we need the numeric conversion here ?

thanks

Replies
11
Views
464

### Re: formula help

hi .

is this shorter ? seems to work with me: (FRI - SAT = OFFDAYS)

@ E7

=SUMPRODUCT((WEEKDAY(E3:T3)<6)*(E4:T4="SICK"))

21. ## Thread: Unsure how to set up Data validation, dependent on value from list

Replies
4
Views
195

### Re: Unsure how to set up Data validation, dependent on value from list

data validation is set on E3
22. ## Thread: Unsure how to set up Data validation, dependent on value from list

Replies
4
Views
195

### Re: Unsure how to set up Data validation, dependent on value from list

dunno i cant understand your problem; can you formulate it on a sheet with the expected behavior and paste here using Mr.Excel HTML maker?

what i understood looks quiet simple and straight...
23. ## Thread: Thank You to the Regulars

Replies
9
Views
1,226

### Re: Thank You to the Regulars

yup the forum is really helping a lot of people, and fresh daily with questions and challenges.

i wish if there is some kind of a compensation and retention mechanism for the effort of the guys...
24. ## Thread: Selecting items only once in a list until that item is returned.

Replies
13
Views
607

### Re: Selecting items only once in a list until that item is returned.

Ahaa

I am not copying and pasting with paste special, am just copying and pasting normally that explains it.

I will try the paste special with validation.