This really helps, the only thing was challenging to me- where we are copying/ applying the formula to all drop down cells. while double clicking on bottom-right corner (+sign) formula was changing the range and was increasing 1 cell for every time. where as i don't want to change the range in formula. In this case you mentioned about using table name- but i was not sure how to create a table for given values in cells and specify that table name in vlookup formula. Thank you for all the videos , those are really helpful and very easy to understand after following your steps.
@TigerSpreadsheetSolutions
5 жыл бұрын
Deepa - thank you for the comment. I am not absolutely sure what you mean, but here are some ideas: If autofill down (ie. double clicking the bottom right square to copy down) is problematic, try a simple copy / paste. You could use pastespecial / formulas. Otherwise, you may need absolute references in the formulae to ensure they point to the right cells. Good luck!
@Tr1pleKYT
Жыл бұрын
Hi I know the answer might be too late but you can select all the columns (by shift clicking A,B,C etc) then click on format as a table. And then under design you can give the table a name and the problem will be solved. As to why it increases 1 everytime even I dont have an answer.
@אסףשרון-ק9ט
4 жыл бұрын
Thanks a lot for a great and a productive video!!! cheers!
@TigerSpreadsheetSolutions
4 жыл бұрын
You're welcome - please check out the other videos on the channel
@aaron2515
2 жыл бұрын
That was very helpful, thanks
@TigerSpreadsheetSolutions
2 жыл бұрын
Thank you and welcome to the channel!
@tutsecret499
Жыл бұрын
What if I want example some nationalities column, employee column staff1, staff 2, etc, depts/agency column, management/positions column, Gender column. Race column(example Japanese, Korea, Filipino, etc would be Asian group that will the Race Column. So the goal is to see which nationality or group is being hired within each Agency, and which gender is hired. So I need data pretending I am collecting an Annual Statistical employment. So can I get data to practice to do the project like getting data, cleaning and reformatting data, summary, pivot ables, power pivot, charts, etc. I just need the data.
@TigerSpreadsheetSolutions
Жыл бұрын
It's all possible with this technique - this is the exact way I generate the kind of dataset you're talking about. It will take some practice, but is perfectly possible - good luck!
@hameedksn6116
6 жыл бұрын
great!!, thank you very much for this beneficial video, good luck
@TigerSpreadsheetSolutions
6 жыл бұрын
Thank you Hameed - good luck to you too, please check out the other videos on the channel.
@3axelerate
2 жыл бұрын
How did you turn the coordinates into the vtable reference?
@melihartar3657
8 жыл бұрын
Hi there. Can I generate a set of data which will exhibit certain characteristics ? For example, I need a data set where the number of observations is 226, mean is 344 and std.dev. is 106.
@TigerSpreadsheetSolutions
8 жыл бұрын
Hi there, I would recommend having a look at the random number generation facility in Excel. I think you have to have the Analysis Toolpack installed to be able to access it, Google will tell you how. Good luck!
@neerajwithe
5 жыл бұрын
Sir,how that range value is automatically entered whenever you entered a value like 0.2,0.4 and so on. Looking for a quick reply
@TigerSpreadsheetSolutions
5 жыл бұрын
I am not absolutely sure what you mean Neeraj - can you explain?
@joaolucaspiresbringel1949
5 жыл бұрын
I think my answer will be too late, but here it goes: =Cell&" - "&Cell, in the video it was, for the first row of range: =B4&" - "&B5
@lukassampson4933
3 жыл бұрын
way too fast to follow, we are not experts
@TigerSpreadsheetSolutions
3 жыл бұрын
half speed?
@khakim9448
Жыл бұрын
it's an age difference I'm watching this at 2x speed playback and I'm 17
Пікірлер: 20