Комментарии:
Hi. Thank you for the tutortial. It's so well explaied and inspiring!
I am doing the standard forumla =LOOKUP(2,1/(A1:A10<>""),A1:A10)
It works in Excel but not working in Google Sheet. What should I do to make it work?
Hi,
I have a data with a different ID and the adjacent column contains numerical value with respect to each ID. I receive every day these data and sometime, some of the ID will not contains numerical value in the adjacent cell. I need to find the difference of a particular ID i.e., today's data with previous data. If the previous data is blank then it has to check the next previous data which contains the numerical value. I dont know how to figure out the formula for this case.
I'm currently working on a billing period spreadsheet that I import the data for each day in a given month. The first column has each day of the month listed for the given billing period, but every month has a different number of days. Sometimes there are 30 rows for days 1-30, 31 rows for days 1-31, etc.
I am using the formula =TEXT(C10,"mm/dd/yy")&" - "&TEXT(C40,"mm/dd/yy") to show the specific dates for the billing period, but "C40" can change to C39, C41, etc., depending on the number of days. I've been doing that manually for each billing period.
Is there a formula that I can use that automatically adjust "C40", in this example, to be variable depending on how many items are in the column?
I'm using COUNTA to get the total number of rows with data in the column C10 to C45 but don't know how to use that in the formula. Do you happen to know of a way for C40 to be variable depending on how much data is in a column?
WHAT A ABOUT A SHIIIIT THAT I HAVE HERE ITS I NEED ONLY THE VALUE IN THE DATE . AND THE VALUE CAN CHANGED AS THE BALANCE EVER DAY CHANGE TWO OR THREE TIMES HOW THE FUCK I WILL FIND THIS BECUASE ALL IN YOURTUBE NO ONE MAD A EXMOLE OF THIS
ОтветитьSir how to select 2nd last numerical value in range.
ОтветитьThank You for the idea, actually, I'm having an issue about the column having an formula. so that, i'm using =NOT(B:B=0) so that the whole number became true and the ZERO cells became false. Thank you again ^_^
ОтветитьGreat
ОтветитьWhat if I want to get the last value from another sheet?
ОтветитьNice one! Below are a few more that would work for everything including ERRORS. Fun to experiment! Thanks for sharing all your tips and tricks :)) Thumbs up!!
=LOOKUP(2,1/NOT(ISBLANK(A:A)),A:A)
=INDEX(A:A,MATCH(2,1/NOT(ISBLANK(A:A))))
=INDEX(A:A,XMATCH(2,--NOT(ISBLANK(A:A)),-1,-1))
=XLOOKUP(2,--NOT(ISBLANK(A:A)),A:A,,-1,-1)
Hi there. I am running Excel 2019 and I have downloaded your Excel worksheet, trying to reproduce your very first example (=INDEX(A1:A6,2), which should return the value "red". Well, upon doing exactly so on my pc, Excel spawns the standard error message for a wrong formula (I have tried many other peoples similar tutorials and the same topic "return the value of last non-blank cell", copy/pasting the given formulas but Excel keeps spawning error messages). Any ideas what I might be doing wrong?
ОтветитьNice voice
ОтветитьI know this is off subject, but do you have any tuts that I could view? I would like to get the VBA code that I can use on a form that will generate a unique number using the MAX (?)function(I think). when the form initializes it knows the last number used in the data sheet and adds the next sequential number in the form where I then enter the remaining of my data before sending everything to the data sheet. each time the form opens it should already have the next highest serial number already populated in the designated field in the form.(would like to use it on your Idiot-Proof Form.
ОтветитьGreat Tutorial..Nice And Easy To Understand!Thank You Sir :-)
ОтветитьGood tutorial! Thank you very much!!
Ответить