Excellent comparison BUT could be GREAT if you could add query and select sql statement which in my opinion is more flexible and customizable method of filtering data. Thank you.
Oooh, I'll put that on my list for a possible topic next time. I've only been playing with QUERY for a year or so but making a video like that on it would be an eye opener.
I am about to cry please help? :( I used a free GS budgeting tool and one tab is for a list of 'non fixed income' categories. If you add to this list of categories it will auto populate them onto a diff tab. My issue is, there were say 10 dummy categories which I could type over. And then if I have more I must add more row. However, any categories in newly added rows will not populate onto the other tabs. Why? How do I fix this. Its basically a master list which if edited will appear as such in other places. What must I search and watch to understand how to fix this please
If I recall, I stopped using VLookup years ago and replaced it with index match because moving columns around post setup would ruin my VLookup functionality. Does XLookup solve this?
Excellent comparison BUT could be GREAT if you could add query and select sql statement which in my opinion is more flexible and customizable method of filtering data.
Thank you.
Oooh, I'll put that on my list for a possible topic next time. I've only been playing with QUERY for a year or so but making a video like that on it would be an eye opener.
One of the best teachers.. Thanks..
Oh yeah! Thanks.
I am about to cry please help? :( I used a free GS budgeting tool and one tab is for a list of 'non fixed income' categories. If you add to this list of categories it will auto populate them onto a diff tab. My issue is, there were say 10 dummy categories which I could type over. And then if I have more I must add more row. However, any categories in newly added rows will not populate onto the other tabs. Why? How do I fix this. Its basically a master list which if edited will appear as such in other places. What must I search and watch to understand how to fix this please
How can I sum together dollar amounts from a product that is on cheat 2?
If I recall, I stopped using VLookup years ago and replaced it with index match because moving columns around post setup would ruin my VLookup functionality. Does XLookup solve this?
Yes, try it instead of INDEX MATCH. It adjusts for columns being moved.