Hello all,
I have a bit of a variation from the count unique values with 2 criteria...
in this case I have two columns: the first is a list of serial numbers that
does contain duplicates and the second column is the user number that has
used that serial number (also contains duplicates).
For e
>
> Here is the code...
>
Private Sub CommandButton1_Click()
Sheet1.Range("A1").End(xlDown).Offset(1, 0).Value = TextBox1.Value
Sheet1.Range("A1").End(xlDown).Offset(0, 1).Value = TextBox2.Value
Sheet1.Range("A1").End(xlDown).Offset(0, 2).Value = Date + Time
TextBox1.Value = ""
Text
I have a simple userform with 2 textboxes for barcode scanned entries.
Once the user confirms the entries are right, they click a “Confirm” button
that drops the two entries into columns, then clears the textboxes.
Where I’m seeking help is, instead of having the users click a “Confirm”
Vabz, At the bottom of the attached sheet, I highlighted 3 examples and
what the expected return values would be for each example. The coloring is
meant to show which ranges the example criteria would refer to. Is there a
better way to show? Basically I'm lookin a formula that can count the
File attached to try to be more clear on what I'm trying to do.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titl
Here's one:
In A1:A7:
1st
3rd
1st
2nd
3rd
In B1:E1: 3, 2, 5, 4
In C4: cat
In E7: dog
I want to make a formula that will count the number of cells in a range
that contain a string (any string), but that also falls under row and
column criteria.
For example, if the column criteria is "3rd" and
I feel like this should be very easy but somehow I'm stumped on why the
error on "MsgBox Cells(CheckRow,1)". It works if I use "MsgBox Cells(1,1)"
for example.
Help please?
Sub TestCode()
Dim CheckRow As Integer
For Each N In Range("A1:A5")
CheckRow = N.Row - 1
MsgBox Cel
Thank you!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, N
I'm trying to use a For loop to look through a list of dates in a worksheet
and flag cells whose dates are greater than 100 days.
Set Date_Range = Sheets("Sheet1").Range("A1:A500")
YearStartDate = DateSerial(2014, 1, 1)
For Each DateVal In Date_Range
DateAge = DateVal - YearStartDat
I'm trying to get a feel for the "architecture" of this scenario:
- Sheets are setup with hundreds of rows, headers are: item #, type and color
(just 3 for simplicity's sake).
- I need a count of how many rows (items) meet criteria in both the "type" and
"color" columns.
- The criteria for th
I'm looking for some help with one of the components of a SUMPRODUCT
formula that is causing the formula to error:
Starting in A1:
alpha137
beta224
gamma492
in A4: 49
in A5: 2
The idea is for one of the components of the SUMPRODUCT formula to look for
a string (in A4) in each cell in the
I'm trying to figure out the syntax to use a function within the Indirect
function. I would like to do something like this but am getting a #REF error:
=INDIRECT("SUM(A1:A3)")
Where am I going wrong?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
cool thanks. can that same syntax be used for vlookup?
for example:
=VLOOKUP(INDIRECT("A1,B1:C3,2,FALSE"))
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FO
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
I'm trying to figure out how to use a function within the indirect function.
for example, I would like to use a sum function within an indirect function so
I can change the sum range based on a certain cell value. But I apparently
have the wrong syntax. Why does this function return #REF?
=
I am trying to access the contents in the merged cells E2:M2.
This works:
Merge_Value= Sheets("P2").Range("E2").Value
Why doesn't this?:
Merge_Value= Sheets("P2").Range("A2").Offset(0, 5).Value
Is there a better way to try to get at the value?
--~--~-~--~~~---~--~--
20 matches
Mail list logo
