- Видео 59
- Просмотров 1 445 635
Excelchat
США
Добавлен 10 янв 2019
Get instant expert help with Excel and Google Sheets. Thousands of problems solved already by hundreds of vetted and ranked Experts! More at: www.excelchat.co
Видео
Learn How to Use SUMIF with Google Sheets
Просмотров 7 тыс.5 лет назад
Want to learn more about SUMIF and Google Sheets? This post will give you an overview of how to use a SUMIF function inside Google Sheets.
How to Use SUMIF to Sum Cells Based on Background Color
Просмотров 26 тыс.5 лет назад
Read this tutorial to learn how to use the SUMIF function to add the contents of cells based on their color.
How to Use VLOOKUP by Date in Excel
Просмотров 19 тыс.5 лет назад
Want to learn more about how to VLOOKUP by date? This post will give you an overview and example of how use VLOOKUP function by date in Excel.
How to Combine SUMIF with GREATER THAN and LESS THAN Functions
Просмотров 21 тыс.5 лет назад
This piece gives the reader details on using SUMIF to find values GREATER THAN or LESS THAN another value.
How to Count Unique Text Values in a Range in Excel
Просмотров 19 тыс.5 лет назад
Want to learn more about counting unique text values in a range? This post will give you an overview of how to count unique text values in a range in Excel. www.got-it.ai/solutions/excel-chat/excel-tutorial/count/count-unique-text-values-in-a-range
How to Combine the SUMIF and VLOOKUP Functions in Excel
Просмотров 89 тыс.5 лет назад
Learn how to use the SUMIF and VLOOKUP functions together in Excel. www.got-it.ai/solutions/excel-chat/excel-tutorial/vlookup/sumif-and-vlookup
How to Copy a VLOOKUP Formula Down a Column
Просмотров 64 тыс.5 лет назад
If you need to know how to copy a VLOOKUP formula down a colum in Excel, click here for the guide. www.got-it.ai/solutions/excel-chat/excel-tutorial/vlookup/how-do-i-copy-a-vlookup-formula-down-a-column
Minimum if multiple criteria
Просмотров 4,4 тыс.5 лет назад
Want to learn more about getting minimum value if multiple criteria? This post will give you an overview of how to get minimum value if multiple criteria. www.got-it.ai/solutions/excel-chat/excel-tutorial/min-and-max/minimum-if-multiple-criteria
How to Lock a VLOOKUP from a Table Array
Просмотров 39 тыс.5 лет назад
Get detailed instructions on how to lock a VLOOKUP from a table array in Excel. www.got-it.ai/solutions/excel-chat/excel-tutorial/vlookup/how-do-i-lock-a-vlookup-from-a-table-array
How to Use SUMIF Combined with Multiple Criteria
Просмотров 24 тыс.5 лет назад
This how-to piece describes using the SUMIF function combined with multiple criteria in Excel. www.got-it.ai/solutions/excel-chat/excel-tutorial/sumif/sumif-multiple-criteria
How Do You Do Conditional Formatting with 2 Conditions?
Просмотров 13 тыс.5 лет назад
Learn how to use Conditional Formatting with two conditions in Excel and see some examples. www.got-it.ai/solutions/excel-chat/excel-tutorial/conditional-formatting/conditional-formatting-with-2-conditions
How to Use INDEX and MATCH with Multiple Criteria in Excel
Просмотров 12 тыс.5 лет назад
Want to learn how to use the INDEX and MATCH with multiple criteria in Excel? This post will teach you how to use INDEX and MATCH function. www.got-it.ai/solutions/excel-chat/excel-tutorial/lookup/index-and-match-with-multiple-criteria
How to Pull Values from Another Worksheet in Excel
Просмотров 110 тыс.5 лет назад
Here is a guide on pulling values from another worksheet in Excel. www.got-it.ai/solutions/excel-chat/excel-tutorial/vlookup/how-to-pull-values-from-another-worksheet-in-excel
How to Determine IF a Cell is Blank or Not Blank in Excel
Просмотров 10 тыс.5 лет назад
Want to learn more about the IF function? This post will give you an overview of how to use an IF function when cells are blank or not blank. www.got-it.ai/solutions/excel-chat/excel-tutorial/if/blank-not-blank
How to Use VLOOKUP Across Multiple Worksheets
Просмотров 22 тыс.5 лет назад
How to Use VLOOKUP Across Multiple Worksheets
How to Count Colored or Highlighted Cells in Excel
Просмотров 51 тыс.5 лет назад
How to Count Colored or Highlighted Cells in Excel
Learn How to Combine IF Function with VLOOKUP
Просмотров 43 тыс.5 лет назад
Learn How to Combine IF Function with VLOOKUP
How to Use a COUNTIF Function in Google Spreadsheets
Просмотров 25 тыс.5 лет назад
How to Use a COUNTIF Function in Google Spreadsheets
How to Automatically Update Data in Another Sheet in Excel
Просмотров 315 тыс.5 лет назад
How to Automatically Update Data in Another Sheet in Excel
How to Use the Excel SUMPRODUCT Function
Просмотров 4615 лет назад
How to Use the Excel SUMPRODUCT Function
How to Use the Excel CUMIPMT Function
Просмотров 1,6 тыс.5 лет назад
How to Use the Excel CUMIPMT Function
How to Split Text and Numbers with a Formula in Excel
Просмотров 7 тыс.5 лет назад
How to Split Text and Numbers with a Formula in Excel
Learn How to Group Numbers with VLOOKUP
Просмотров 3 тыс.5 лет назад
Learn How to Group Numbers with VLOOKUP
How to Count Table Columns in Excel
Просмотров 4,6 тыс.5 лет назад
How to Count Table Columns in Excel
not useful. use chatgpt guys.
Amazing, finally solved my problem nice and easy, thank you very much!!!
THANK YOU, YES!!! The F4 issue was my problem I've been trying to figure out for an hour!
Hi Kevin, I don't want to drag actually, I want is a query that populate the entire column matching the values in a different sheet altogether. Could you please explain this.
Excellence explanation, many thanks, however if there is blank rows in between the data, what is the formula will be?
Thank you a million.
what about for different workbooks, can you do the same thing?
Really helpful - was going crazy when it wasn't copying the formula correctly! F4 fixed my problem.
What if we want to copy the formatting style. Like =e3>c3 But we want to copy it to other blocks so that: When you paste it it will be =e4>c4 (Instead of e3 and c3
Thank you for your help :)
For the life of me, I can’t get absolute cell reference to work. Nothing happens when I hit F4 or Fn+4
Thanks excel chat, that's a little different from the way I was thinking, but I'll give it a try, 👍🏾.
waste of time👎👎👎👎👎👎👎👎
F4 tip and adding 0 for exact match helped. It really was this exact tip which resolved the issue
Thanks for the F4 tip - that was exactly why I was having trouble.
Amazing, saved me a lot of time
JUST SAVED ME A LOT OF TIME LOL
Thank so much
This is by far a better explanation than the others I have found on RUclips because of two reasons. First you focused on the syntax so I got to see how I need to actually enter the equation like the +1. Second you did not give us an hour long explanation of why this works like every other vid I clicked on. I could care less exactly why this works when trying to finish a complex spreadsheet late at night. So having some one show this in a way that I was able to use to complete what I was working on was very helpful. I have subscribed, but also bookmarked in a special sub folder in my excel tips links.
No latest video??
Why does your values in column A change during demonstration? A2 starts with 71 and A4 = 294, then at 1:21 after you enter Match formula into C2, A2 changes to 72 and A4 changes to 287. What happen to A2 = 71? Then at 2:02 after you hit Enter A2 changes to 67 and A4 = 81. This continues through demonstration.
You didn't explain what anchoring is or how to do that. Could you clarify please?
Thank you so much!
Thanks to share , it helped me out to do my work
I love u man thanks so much man 50 seconds into video fix my problem I had for an hour love love love
how to automatically increase or decrease values in a sheet using values from another sheet
Is there an easier way to get an =SUM() for cells in different locations?
Amazing clear and simple thank you
What happened at ‘NCHOR THAT’/???
Thank you so much for this info!
dude talks so fast you can't even understand his name.
Please remove any music from your videos, thanks in advance.
thank you so much really a great help
Too fast.
Thank you soooooo much! I am creating my own Expenses Log and I have been having a hard time trying to break everything down by categories, this video just showed me exactly what I have to do for my calculations.
Thank You
very nice thank you
It worked very well.
Very useful. Thanks!
Man this channel helps me a lot!
Is he still active? The method he should for VLOOKUP on multiple column, is wrong and won't work. Someone has pointed out 1 year ago, but he has not yet removed the video. Believing this video, I lost 4 hours before realizing that it is wrong and I need to create an additional column containing the concatenated values for searching purpose.
i found a cool video showing something like that. I think Option 3 is using an XLOOKUP, it lets you select exactly what you want to search, even lets you return values to the left of the search... xlook (search, where, return) ...so XLOOKUP(C1&C2&C3 , Table!B:B&Table!C:C&Table!D:D, Table!A:A) ruclips.net/video/70rKo3USOSw/видео.html
Will this also capture new entries? I need something that will mirror the entire sheet. There's a server copy of a Workbook and each of us has our own working copy we can filter and manipulate. When there are updates to the master, we want our copies to be automatically updated. These updates could include new row entries, updates to existing cells, and in rare cases, new columns.
I want to keep 0s in data but not blank cells
thanks, good job!
Thank you! Best vid ever
this was great, thank you. saved my hours of work
Quick question. I have a conditional formatting (use a formula to determine cells to format) on cells A1→I1. The formula I use the formula = J1(select the cell) ="Yes". This will change the colors of the cells A1→I1 green whenever cell J1 has the word "Yes" within the cell. Is there a way to copy that conditional format and paste it to the next row so that the next set of cells will do the same except instead of looking at J1 it will look at J2. I want to repeat this process over the next 20 rows without having to enter it.
Were you able to figure it out? I’m in the same situation
@@manuelgallegos9411 Unfortunately now. You can copy drag down the cell but it still looks at J1. I suppose you can just go into each one and edit to J2.
Wow super fast talking, was hard to keep up. There are beginners here :(
Thank you! What a great solution for this.
thanks