-
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.
succeed
-
H
Combine formulas
Hello there, I have a formula which extract a specific word from a cell and I could succeed : =LEFT(MID(K2;FIND(" ";K2)+1;LEN(K2));FIND("/";MID(K2;FIND(" ";K2)+1;LEN(K2)))-1) The result is "100ml" After, my goal was to separate "100" and "ml" to make "100 ml" and I could also succeed with...- HatchetHarry
- Thread
- excel formula harry make succeed
- Replies: 8
- Forum: Excel Questions
-
S
sum repeated rows
Hi, I need to sum up the repeated rows to a new table, like in the pic. never tried this before tried all kind of formulas but didnt succeed :-( should i even use functions? maybe PIVOT? VBA?? would much appreciate your help.- SHAYJ
- Thread
- functions repeated rows succeed sum
- Replies: 5
- Forum: Excel Questions
-
M
Using CountIF in VBA - Something wrong with range - 1 row of code only
everynumber = Application.WorksheetFunction.CountIf(Range(“A1, AD1000”, ">0")) Hi! It just doesn't work, I tried everything to get along with this CountIf Function but I just doesn't succeed. Could you help me out please? Have a nice day!- makiwara
- Thread
- countif day function nice succeed
- Replies: 1
- Forum: Excel Questions
-
A
Convert Sheet1 into Sheet2 format using PQ
Hi MarcelBeug and All, I have a data on Sheet1 which I want to be look like sheet2. I have unpivoted all columns except the first one and Im stuck and can't go further ahead. Mr. MarcelBeug helped me in the past and I tried his steps here but didn't succeed. I think I am doing something wrong...- alipezu
- Thread
- marcelbeug past sheet1 sheet2 succeed
- Replies: 6
- Forum: Power Tools
