-
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.
shed
-
J
VLOOKUP Max Find
I am trying to find the MAX date and time value in a column using VLOOKUP. Below is the code I have. I know it doesn't work. Can anyone shed some light?? =IF(K18="","",VLOOKUP(MAX(J17,J18:K114,2,FALSE))) Thank you for your support in advance.- Jayliam
- Thread
- find max shed vlookup work
- Replies: 3
- Forum: Excel Questions
-
H
Reading Text File, stopping unexpectedly.
Hi, I have a text file(.XER), VBA can iterate through the file until it gets to this line: Screenshot(middle line) https://unsee.cc/81c0f29e/ Copied and pasted %R 190489 77906 nvirnImpaAssem/SiteWsteManagPlan�@_ It seems as though this line causes the while loop to exit. Can anyone...- hamerish
- Thread
- file light line shed text
- Replies: 1
- Forum: Excel Questions
-
H
Extracting Data from a PDF using VBA?
Is it possible to extract data from a PDF using VBA? For example, an invoice? If so, can somebody please shed any light on how this can be done? Thank you!- hellfire45
- Thread
- data light pdf shed vba
- Replies: 2
- Forum: Excel Questions
-
M
Referencing to a Sheet in Excel Formula
Hi All, I have two sheets and one called Week1. This formula works for me from the other sheet: =INDEX(Week1!$G$3:$G$50,MATCH($C6,Week1!$B$3:$B$50,0)) However, I would like to replace Week1 in the formula with a text string I type say in cell A1. This is where I get stuck. Can someone shed...- mikewongbiz
- Thread
- formula shed sheet stuck week1
- Replies: 3
- Forum: Excel Questions
