Комментарии:
I just used ,Very use full , thanks
ОтветитьThanks Sir
ОтветитьCan you do this with an IF function?
ОтветитьHello Sir, I need help for one excel file, could you please help me on that. can I email you the file and can you get me the exact value
ОтветитьThank you. Answered my question in a few seconds :D
ОтветитьHow can I use excel to find the value of multiple data cells from a table and sum the total amount by using one formula??
ОтветитьWhen the match works - I want to show B, C and D separately - Please let me know how? Thanks.
ОтветитьHOW is that better than =sum(A2:D2)???
ОтветитьThanks, very simplified and helpful
ОтветитьWhats the difference between this and index
ОтветитьHello how r u sir
ОтветитьWhat if i need to see multiple value instead of doing sum or average
Ответить🦅🐤看妹妹私🈲️视频➕微信号hot5383🐤🐦个风风光光个发复古哥哥让我们来一起
ОтветитьGreat
Ответитьi am trying to schedule tests with different durations for multiple people :-0
Ответитьcan do a video with times? :-)
ОтветитьI saw your video. It's really helpful but what I need to do is to apply to the cell B10 values of different cells in row 2 depend on selecting different month from a drop-down list.
let say applying vlookup in a conditional way based on monthly criteria.
Could you please help me.
You talk very fast.
ОтветитьThanks Exactly what I looking for
ОтветитьDear Sir,
I am kindly requesting you to help me particularly in this section...... I have 2 Sheets in Book1.. Sheet1 has 6 Columns with data and 39 Rows With data and sheet2 has 6 Columns with data and 41 Rows with data. I want to find out differences one (Not Common) between these two Sheets Sheet1 and Sheet2.
Could you kindly Explain Formula In detailed way.. as early as possible
Sincerely Thanking you,
Basvaraj,
This is great! What if you have a spreadsheet with multiple "Jacks." Can you still get all the information and still have it added together? Thanks!
ОтветитьHow to if i want Jan. Fab .March Data in different columns by base value ?
Ответитьthank you, a brilliant presentation. Indeed a great help.
ОтветитьThis video was so helpful to find the sum from one sheet, if i have 2 sheet and the sum has to be calculated. how can i do it
{=IFERROR(SUM(VLOOKUP(B3,'FUEL CARD PIVOT'!A:AG,{3,4,5,6,7,8,9,10},FALSE)),"-")}
this the fomula i used for single sheet ( it for 8 days )
thanks my dear
Ответить594????? You mean 954
ОтветитьThanks for sharing. How would I display the values, matched with Vlookup, in adjacent columns first before applying a function like sum or average to them? For example, given the same layout as above, how would I display the lookup values in separate, but adjacent columns for January, February and March. Would I have to create a unique lookup formula for each column or could I use a constant array as you have done in the video. Thanks, Sam
ОтветитьHello, If i need to get sum of all the enteries in coloum B, into H1 and Coloum C into H2, All entries in Coloum D in H3 and so on is their any formula for it
Ie while i enter the formula in H1 and drag it down i need to get all the value of different coloums in Coloum H as explained above.
Have you made one to show how to do this for multiple sheets of data?
ОтветитьHow do I search in multiple columns though?
I've got a list from Fedex of Countries, but the data to search is going to be written by more than one source, so I need to create a more robust search.
One system might write USA, while another might write United States, while another might write US or U.S.
So I've set up all "basic" variations in a table. I want to search through the entire table with the vlookup, but it's only doing the search on the first column. My longest set of variables is out to column L, so I have a table of data B:L. It only checks criterion data against column B.
How do I tell it to search ALL columns under the table?
As with DW721's comment, this is what I'm looking for but have many rows then your small dataset. How can I expand that small array of {2,3,4} to the whole column of rows or many, many rows?
ОтветитьCan this be done with multiple rows instead of columns? For instance, I have an excel file of clients and the amounts they owe. They may be listed multiple times with different amounts owed. I essentially want to combine all of their amounts into one. This looks like what I need, but with rows instead of columns.
ОтветитьSir, Thanks for sharing the video. I had a query that when there is an employee whose name is Adhi holding employee ID 101 and his spouse with employee ID 101 name is Diya , how can i get different names using vlook up. I have tried it but the result I get is Adhi for both as same ID I have used and it takes first name. Actually I want to get spouse name in second row.. Please help me on it
Ответитьso i have an excel sheet with many employee numbers and first and last
name of employee in one sheet on a second sheet i have only couple
selected employees. How can i filter my main database to only those few
workers on the second sheet. I have pasted an example.
sheet 1 with all users information.
Employee #
FIRST_NAME
LAST_NAME
102698
Nancy
Becton
103671
Robert
Brackins
107697
Jack
Eknath
111561
Ruth
Jackson-hill
113623
Sandra
La Farge
116303
Janet
Lemus
116730
Suryaprabha
Medina
116860
Ruby
Newton
117026
Paula
Smoot
117187
Sandra
Stewart
117243
Lisa
Yoder
117414
Patsy
Zantiny
On sheet 2
Employee #
FIRST_NAME
LAST_NAME
103671
Robert
Brackins
113623
Sandra
La Farge
116860
Ruby
Newton
117243
Lisa
Yoder
On sheet 1 I want to look up only those people on sheet 2. how can i filter this, please help
nice cheers doug, how do i complete a vlookup which allows me to pull multiple columns of data into multiple cells. rather then using multiple sheet and cell references as individuals. i basically have a master data sheets that I use to create a dashboard in another sheet, but at the moment Im am linking cells individually from one sheet to the next.
ОтветитьThis was very good. Is there a way to have a drop down to change the sum to average or to count...etc?
Ответить