Latest activity
-
shamimarita replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.You are most welcome. I hope your problem is solved now. -
shamimarita reacted to 2018acway's post in the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria with
Love.
Thank you very much for all your help. -
22018acway replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.Thank you very much for all your help.
-
shamimarita replied to the thread [Solved] Data Entry Sheet.Hello, The row calculation is adjusted to lastRow + i + 1 to start from the next empty row. Make sure the TextBox1 contains the correct...
-
shamimarita replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.You can use this formula: =VLOOKUP([@FIN],AB:AC,2) Insert the flight number manually as the flight number is not aligned with the fin...
-
-
Ssems711 replied to the thread [Solved] Data Entry Sheet.Hi! I added this code but it was not adding the serial numbers into the table and not all the values were being added. Is there any way...
-
22018acway replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.Everyday flight numbers have a different fin number associated to them. So, I need the formula to pick up the correct aircraft type.
-
shamimarita replied to the thread I have a full content in a column, can we make MCQ using excel GPT?.Hello Nazmul, To automate the process of creating quizzes from the data in your Google Sheet. Follow the steps given below: Place the...
-
-
shamimarita replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.Where is 1093 in the corresponding fin number and aircraft type? There is no fin number for the flight number 1093 I request you to...
-
-
22018acway replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.Thank you for your continuous assistance. I know your time is valuable. I tried your formula and I still get the N/A. I entered flight...
-
Nnazmulisrony posted the thread I have a full content in a column, can we make MCQ using excel GPT? in Excel Formulas.I have sql database on my voltage lab electrical site. I have export database on google excel sheet, can i make automation quiz from...
-
shamimarita replied to the thread libre office calc.Hello HLIASBLX, Thanks for sharing the Excel file. However, it would be helpful if you could provide more details about the issue...
-
shamimarita replied to the thread [Solved] Lookup Values from Large Dataset based on Multiple Criteria.A2 is not used in the formula how will it impact the formula to show error? Your formula is incorrect: =INDEX(AC:AC, MATCH(1...
-
shamimarita reacted to bkelley@ensembleartsphill's post in the thread Specific Question Regarding Auto Populating between Worksheets with
Like.
Also how should I edit the formula if there are two venues entered in Column F and I need the prices for both venues to be added... -
shamimarita reacted to bkelley@ensembleartsphill's post in the thread Specific Question Regarding Auto Populating between Worksheets with Like.
Thank you! I think I figured it out. Now I do have over 100 rows that need prices autopopulated. Is there a way to copy the formula for...
