excel & formula

What formula can I use to mark the middle column with a True or False if the ticket number is found in the winning tickets? I tried using =IF(VLOOKUP(AF2641, 'Ticket Number'!$A:$A,1,FALSE),TRUE,FALSE) but ran into problems when other numbers were checked. Ticket Number Winning Tickets...

Dear All, In the below pivot table I dont need the monthly sum of GM (Which I have marked with a cross symbol). However I need a total at last ( as shown with a TICK symbol). Is there any option to do this? Please note that I need the monthly revenue and cost figures as it is. Only the GM...

Hi all - I am very new to using Macros with Excel and I am looking for help. I am using code to attempt to automatically generate a word doc with upcoming deadlines/due dates in my Excel sheet. Currently, it will only generate a word doc if I manually run the code. Also, I am having trouble...

Hi, I have two tables, A and B. Table A is countries planned and Table B is planed driven KM. I also have a summary where I want to see total planed KM, per country, and what calendar weeks that specific country is planed. I have a formula that summarizes planed driven km in a set of specific...

Hello, I am trying to rearrange the columns from a downloaded survey into a template to be able to upload it to a website. In the file attached I would like to copy the values in sheet "Data" into the sheet "Template" where the columns match by the question Code? I have tried 2 different...

I have a sheet (Attached), where I want to change the value of the total billable hours to reach a target utilization, but it's not working properly, appreciate any pointers. A B C E F G H I J K From 1/7/2023 to 30/8/2023 Working Days Target Hours Available for Work To be charged...

Hey, we have a 4-4-5 week finance period structure. Our Finance year runs Jan - Dec with a 4 week 4 week 5 week quarter I'm building a model where the first month will change, based on our finance structure I want excel to tell me if it's a 4 or 5 week month, so to return "4" or "5" based on the...

Hi Friends, I need to copy each EX1, EX2, and EX3 value from cells A2, B2, and C2 then I need to transpose and paste it in column F2. But the issue here is, when I paste I need to replicate the value three times :(. The below table is just an example with 2 rows, but actually, I have around...

Hi to all, I have a formula that has an 1-dim array like this: {0,0,0,0,0,0,1,1,0,1,0,0,0,1,1,1} and if I want to search "1", the result is position is 7. =MATCH(1,{0,0,0,0,0,0,1,1,0,1,0,0,0,1,1,1},0) = 7 now, if I have a 2-dim array (4x4), is there a way to look the position of first "1"...

Hello, Would anybody know, if this is even possible, a formula to enter the number of the last row with data in the file attached, so I don't need to updated the formulas every time we add rows ? Any help is welcomed. Thank you ABCDEFG1 name artist staffDistinct People5missing data from rolls...

Hello, I am trying to find how to show the number of distinct Artists and Staff in the file attached. I have manage to find the distinct number of people as a whole but coudn't do it when try to add fiuther criterias to find out the number of distinct staff or artist. Any help is welcomed. ABC1...

Hi there, I have a sheet where I want to sum up hours for a person per month. Tasks are entered on a row basis where the user enters the name in column C, hours per task for each month column H contains Jul, column H contains Aug, etc On a separate sheet I want to sum all the hours for...

I use excel and i have sheet look like : A B C 1 3927269 58516305 2 2356361 3 2749088 4 294545 5 13156350 6 1570908 7 1963634 8 5105449 9 3632724 10 3141815 11 7996358 12 3534542 13...

Hi, I want to populate a cell when I click another cell Example: I have a list of data in Column A, if I click any of the cells in Column A the value in that cell should populate to B1 or some cell which we want

Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...

Can u help me to combining this formula into 1 Formula? :)

Hi All, I'm seeking out for help to generate a formula, that can check for the blank values for an attribute against an identifier. The identifier can have multiple records, but if atleast one of the record is blank, then default to blank for all the other records associated to the same...

Hi everyone, I am trying to match day and month between two dates, as mentioned below these dates do not have years only Day and month. for example B C D B3 = Start Date...

Hi I need a formula in excel 365 to find the distance in km between two coordinates (longitude ,latitude) I had tried these twos formulas =6371 * ACOS(COS(RADIANS(90-B2)) * COS(RADIANS(90-B3)) + SIN(RADIANS(90-B2)) * SIN(RADIANS(90-B3)) * COS(RADIANS(A2-A3)))...

Good Morning, Everyone is doing well !! Though I am still in the learning phase and in past years learned so much from Forums and Youtube videos. Need help with the below code where I have successfully saved the files in a folder by giving them a location and the location we need to put in...