-
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.
shortened
-
sheetlist sumifs with multiple criteria - shortened?
Is there a way I can shorten this formula. Works - This adds "US", "VI", "PR", and excludes "CA"...- Long Nose
- Thread
- indirect multiple criteria sheetlist shortened sumifs sumproduct
- Replies: 4
- Forum: Excel Questions
-
L
Nesting Multiple Tests Of MkDir's?
Hi, If I wanted to test if any of these filepaths exist and if not to create, what would be the simplest way to nest create? e.g. S:\Folder1\Folder2\Folder3\Folder4 What I've been using is.. but can it be shortened? If Len(Dir("S:\Folder1\", vbDirectory)) = 0 Then MkDir ("S:\Folder1\"...- Lewzerrrr
- Thread
- create end mkdir shortened vbdirectory
- Replies: 2
- Forum: Excel Questions
-
Z
Continuation of Excel Formula
Hi, I am trying to enter the following code so the following formula copies in column E but keep getting an error. The formula is about 3 times longer, I shortened it for the post. With Sheets("data") .Range("E9:E" & .Cells(.Rows.Count, "A").End(xlUp).Row).Formula ="...- zalik22
- Thread
- error formula longer shortened times
- Replies: 5
- Forum: Excel Questions
-
B
Matching cells' values (cell contains a string from another cell)
Hello! I have a problem, which I'm thinking about for some time already and didn't find any solution yet (and have to do it manually). I have two columns in two seperate sheets: FIRST contains shortened names of some products (for example: "Lamp") SECOND contains full names of these products...- bukimi
- Thread
- cell columns lamp products shortened
- Replies: 5
- Forum: Excel Questions
