-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
range_average
-
Vba: calculate average under certain conditions
Hello everybody. I have column J - populated only by numbers except for the header - for which I need the average value. Dim lastrow_g As Long lastrow_g = Cells(Rows.Count, "J").End(xlUp).Row Dim range_average As Range Set range_average = Range("J2:J" & lastrow_g) Dim aver as Variant aver =...- Nelson78
- Thread
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Unprotecting a sheet once a text box is selected
- Started by dpaton05
- Replies: 49
Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text... -
OFFSET function with multiple table
- Started by xdenama
- Replies: 43
I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet... -
Question about Data Validation.
- Started by omairhe
- Replies: 24
Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers... -
VLookup Or Other To Match Data.
- Started by fintail99
- Replies: 23
Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total... -
Split a year range into one row per year
- Started by rameez788
- Replies: 21
Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right... -
Combine 2 var into 1 string with & in between
- Started by bumbum2812
- Replies: 21
Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...