![Excel Situation](/img/default-banner.jpg)
- 65
- 1 129 946
Excel Situation
Приєднався 15 гру 2013
Excel Vlookup visible (filtered) data
This shows a way to use a Vlookup on visible (filtered) data only.
Переглядів: 59 199
Відео
Excel avg excluding zeros on filtered (visible) data
Переглядів 3,1 тис.9 років тому
This shows a way to calculate an average excluding zeros on filtered data.
Excel date converted into 3 letter month abbreviation
Переглядів 9 тис.9 років тому
This shows a way to convert a date into a 3 letter month abbreviation for monthly summarizing.
Excel fill non-repeated names and catch changes
Переглядів 3869 років тому
This shows a way to fill non-repeated names down through a column and catch the changes as they occur all the way down.
Excel Conditional Formatting icon sets with a relative reference formula
Переглядів 31 тис.9 років тому
This shows a way to use conditional formatting icon sets with a relative reference formula.
Excel Finding duplicates across sheets
Переглядів 195 тис.9 років тому
This shows a way to identify duplicates across sheets and their location.
Excel Line Chart don't chart blanks
Переглядів 39 тис.10 років тому
This shows a way to have a line chart stop at a blank rather than dropping down to the zero axis.
Excel Bar Chart Suppress Zeros
Переглядів 59 тис.10 років тому
This shows a way to suppress zeros on a bar chart when using data labels.
Excel not sorting correctly (off of a formula)
Переглядів 48 тис.10 років тому
This shows a possible cause (and fix) for sorting confusion when sorting off of a formula.
Excel info comments visible after scrolling with frozen panes
Переглядів 38910 років тому
This shows a way to use clickable comments that are visible even after scrolling on a sheet with frozen panes.
Excel Finding (Counting) Errors
Переглядів 2,2 тис.10 років тому
This shows a way to find errors via a formula (s) without having to visually scan for them.
Excel formatting calculated numbers joined onto text
Переглядів 20710 років тому
This shows a way to format the numbers from a calculated formula when you want to join it onto text.
Excel Numbers or Text; calculations not working
Переглядів 83 тис.10 років тому
This shows a way to identify formatting (numbers v text) and how to change to numbers so your mathematical formulas work correctly.
Excel conditional formatting based on a formula
Переглядів 73710 років тому
This shows a way to highlight cells based on the result of a formula with conditional formatting.
Excel sum numbers in the same cell as text
Переглядів 44 тис.10 років тому
This shows a way to sum the numbers that are joined with text in the same cell.
Excel Setting Sales Quota (Goal; Objective)
Переглядів 11 тис.10 років тому
Excel Setting Sales Quota (Goal; Objective)
Excel Sumifs visible (filtered) data
Переглядів 44 тис.10 років тому
Excel Sumifs visible (filtered) data
Excel Countifs visible (filtered) data
Переглядів 42 тис.10 років тому
Excel Countifs visible (filtered) data
Excel Countif visible (filtered) data
Переглядів 33 тис.10 років тому
Excel Countif visible (filtered) data
Excel sum based on multiple criteria using Sumifs
Переглядів 1,2 тис.10 років тому
Excel sum based on multiple criteria using Sumifs
Excel sum based on one criteria using Sumif
Переглядів 6510 років тому
Excel sum based on one criteria using Sumif
Excel correct data entry via data validation
Переглядів 10910 років тому
Excel correct data entry via data validation
Excel conditional formatting on target value
Переглядів 2,2 тис.10 років тому
Excel conditional formatting on target value
This helped me. Thank you!!!
Thanks my friend ❤
gracias por la actualización! muy buena!
Thanks
Thanks - clear, to the point advice that works
thanks, it's helping even 9 years after you posted the solution
Fantastic, why this information is never included in all of the responses by the so-called experts on issues with sorting data is beyond me. Top marks for this solution.
thank you so much.. it works
Such a simple solution. Thank you!
You saved me so much time! I was pulling my hair out doing these budget forecast for work and the only thing my boss wanted fixed by Monday was the sorting issue. You're the goat!
OMFG years struggling with thouse items on my files. Thank you so much and god bless you.
Hi , Thanks You so much, it was very helpful.
Thank you very much for helping me out for my tax returns!
Thanks
You have saved my life, my dear friend ❤
thank you! very much for the quickest help 🤩
Hell ya! Thanks so much - huge help
Thank you 🙏🏾 for sharing
You are a saviour❤
just saved my job 😂
this is very nice. thanks a lot. kind of saved my job. 👍
Thanks very useful
nice. if doesn't work, you have to save spreadsheet for scrollbar to reset
Breaking my brain on this for days. Searched Reddit, stack overflow, Microsoft community. Hadn't seen this mentioned *anywhere* as a possible culprit. In a less than 2 minute video, you saved me so much headache
9 years old video helping me in 2024. THANKS BRO
this is my biggest pet peeve with excel
Amazing! Thank you very much.
thank you very much 👍👍👍👍👍👍👍
Thank you!😊
very helpful, thank you for the tutorial
Man you save my life
Super 😮😮
Great Job 👍
Thank you from September 2023
PICA
Now I try to remove these May and Jun with 0 values without filtering. is this possible?
Omg you have no ideia of how much you have helped me. I’ve trying to solve this issue for more than a month and I did what you said and not excel is sorting my table correctly! Thank you so much
THank you, But what if I am using multiple sheets for the formula?
Also check to see if your "numbers" have a hidden (not really hidden just hard to see) blank space...that will really mess things up...the type( ) will not work, you will get a #value error and the multiply by 1 or add 0 also wont work. I still would expect the format cells thing to work. F Microsuck, that format cells should detect the blank and still convert the text to a number. Idiots.
absolutely should not have to multiply by 1. MS has the format cells THAT DOES NOT WORK AS ADVERTISED.
Why in the F would Microsuck not allow a user to reformat cells from text to numbers while giving the appearance that it does exactly that but then DOESTN! INFURIATING.
Thank you for the excellent explanation. However, it does not fix my problem. Finally, I noticed that the comma "," was the problem maker in my case (it was currency in Indian system lakhs & thousands instead of standard 1000 separator). I replaced the "," with blanks using find and replace which solved my problem. Once again thanks for ISTEXT and TYPE functions.
This is excellent!! Thank you so much!👏I was highlighting different data sets to add filters to each set and I would do one set which would undo the other. Your solution was genius and saved me so much time because I was about to put a different data set on separate tabs, but your solution is easier and quicker. Thank you.
Thank you so much! The paste-multiply was the only solution for my issue and never would have thought of it! :) I was in some weird infinite loop trying to figure out why things weren't matching between two large sets of data. Excel is the best! Thank you for your service in making so many people better as a result!
How do you convert series of numbers into date? For example I have 1231206 and want to convert it to 12/06/23? So there is the 1 extra in front of yymmdd...is there a simple formula to convert that into a date? Thanks
I appreciate you getting me through Econ 262, Thank you sir
THANKS FOR SHARING ...I WASTED SO MUCH TIME TO LEARN THIS....BUT YOU DID IT WITHIN NO TIME.....THANK YOU
Thanks dude
Thanks for sharing this fantastic solution. This is very helpful.
How do you use SUMIf function based on filtered data, for example i am looking for a negative and positive values in same column but it will give me grand total, but i want a total of both negative and positive values based of a certain date. could you help ?