-
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.
proficient
-
C
Lookup matching value in rows with duplicates
https://imgur.com/a/XkGTIy5 See above link. I want to find the lowest value of DEF. I have tried multple versions of vlookup, index/match/min. I am not able to get it done properly. Needs to be a function as i am not proficient with VBA.- coban
- Thread
- function lookup proficient properly vlookup
- Replies: 3
- Forum: Excel Questions
-
J
Search table and transfer data
I'm new to the VBA world so I am unsure of even where to start with this one. What I have is a table with names and how far along those people are in there training in different areas. What I want to do is search that table for everyone who is training/basic in a certain area and copy their...- jwhackle
- Thread
- basic data proficient table training
- Replies: 1
- Forum: Excel Questions
-
Y
Help with formula...if I knew how to correctly word it, I may already know how to fix it
Example: =sum('Home/Away'!D5/'Home/Away'!G25*(-100)) This gives me a number. I need to add to this and I am not sure how... I need this to calculate... but then I also need a "if that answer is > than 100, then add 200 to the answer. Any help is very much appreciated! I am sure it is...- ywoodz
- Thread
- add answer patient proficient vote
- Replies: 3
- Forum: Excel Questions
