-
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.
ez svork
-
Hide sheets so you cannot see them without the password
Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...- Jyggalag
- Thread
- code excel ez sverk ez svork fast help index indexmatch jonas edelhard sværke jonas sværke match svorkus dorkus svorkus xd vba vlookup
- Replies: 7
- Forum: Excel Questions
-
How to SUM fast based on dates?
Hi all, I currently have the following setup: Is there an easy way to SUM this for each date? I realize that I can do something like this: However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new...- Jyggalag
- Thread
- datalogi advanced programming excel & formula ez sverk ez svork ez win 16-0 ez win guys formula gabe horn haha ez win guys help coding my conditions jonas edelhard sværke jonas sværke jonas sværke advanced programming jonas sværke ap sumif sumifs svorktallica
- Replies: 3
- Forum: Excel Questions
-
Make a small percentage increase seem big in a chart - IDEAS?
Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...- Jyggalag
- Thread
- &indexdd chart code csv excel ez sverk ez svork haha ez win guys help hlookup indexmatch insert jonas edelhard sværke jonas sværke sakul ekrævs sakul svork sanoj ekrævs so ez sverktallica svork svorkie svorkieboy svorkster svorktallica sværke vba vlookup xdd xlookup
- Replies: 8
- Forum: Excel Questions
-
Alternative to Vlookup when dealing with two criterias?
Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...- Jyggalag
- Thread
- edelhard ez svork ezz svork hlookup indexmatch jonas edelhard sværke jonas sværke lookup sanoj ekrævs snake svork svorktallica vba vlookup xlookup
- Replies: 5
- Forum: Excel Questions
-
How to unhide hidden rows and columns?
Hi all, This may seem super simple and silly to ask, but I have currently made this setup: I have hidden EVERYTHING except for rows and column 1-7. However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...- Jyggalag
- Thread
- bongbong marcos excel ez 16-0 guys ez sverk ez svork ez win 16-0 ezz ezz svork ezzus sverkus formula haha ez win guys help hide index indexmatch jonas sværke match sanoj ekrævs unhide vba vlookup
- Replies: 4
- Forum: Excel Questions
-
Make formula return date instead of value
Hi all, I have this very complex formula: It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format. Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :( If anybody can help me...- Jyggalag
- Thread
- date easy excel ez sverk ez svork ezz ezzus ezzus sverkus fast formula help index indexmatch jonas sværke match sanoj ekrævs sverk sverkieboy sverknation sverktallica svonkie svorkie svorkieboy svorknation svorktallica svorkus vba
- Replies: 3
- Forum: Excel Questions
