-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
offset and text
-
M
Selecting data from two different columns and rows and making a new calendar
Hi! (THIS IS MY FIRST FORUM POST!) I have been making a schedule for school, we have two terms running concurrently with multiple disciplines, instructors, rooms, and lessons. I have 3 sheets that are important: T1T4-Actual Calendar with drop boxes that connect to the class list, including...- Mollybop
- Thread
- calendar calendar problem indirect offset and text schedule help
- Replies: 0
- Forum: Excel Questions
-
W
If False Do Nothing
How do you do Friends, I have a large data set and I would like to search for a keyword and update the cell 5 columns over from it. This is what I have so far: Sub Find_and_Write() Dim X As Variant, F As Range X = Application.InputBox("Enter Value") If TypeName(X) = "Boolean" Then Exit Sub...- Winchester1894
- Thread
- column find function for loop offset and text vba & excel
- Replies: 4
- Forum: Excel Questions
-
G
Average Last x cells excluding Blanks Cells and Text
I have a massive stats based excel spreadsheet that new data gets imported daily. I need to get the average of the last x games ("x" so I can select the number of games to average). What I thought was going to be a basic average(offset) formula has turned into a nightmare. The problem that I...- Grunter31
- Thread
- offset and text offset formula help offset rows isblank if
- Replies: 5
- Forum: Excel Questions
