-
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.
if value
-
L
Delete Row if value found from list of things to be removed
I’ve inherited a transactional database that’s causing meproblems as there’s no governance around changing things… Fix #1 I guess! In the meantime, I’m trying to get a solution. What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already) It then...- LittlegmoonBH
- Thread
- delete a row if value things variable list vba & excel 2016
- Replies: 1
- Forum: Excel Questions
-
W
Find the minimum value based on another column
Hi, I have a table with ID numbers that repeat in some sections, in each of them, it will have a different K value. There is 3 possibilities, 0 indicates INPUT (IN), the maximum value is LATERAL OUTPUT (OUT L) and the middle one is DIRECT OUTPUT (OUT D). How can i do this?- willian2142
- Thread
- if value lookup matrix maximum minimum
- Replies: 6
- Forum: Excel Questions
-
A
IF text value in column A, SUM Column B+C, Otherwise Display Zero
Having a hard time finding another thread addressing this exact situation. Hopefully someone can help: IF there is a text value in column A, I want to SUM Column B+C. If there is no text value in column A, I want to display 0 (zero). Greatly appreciate any help. Thanks, Andy- Analyst 007
- Thread
- if value
- Replies: 7
- Forum: Excel Questions
-
K
sumif in up to 4 different series
Hello, I have a boggle with some calculations that would be nice to solve without a macro. I have a sheet where there can be up to 4 series of numbers in the same row (one year layout - Jan, Feb, etc. - 365 cells). I have 4 cells, where I would like to sum the value of series 1, series 2...- karlaane
- Thread
- if value series sum
- Replies: 7
- Forum: Excel Questions
