excel & formula

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...

I am trying for formula in excel to split the word in to digits on each separate cell in same row, as described below. B10 = Mirza Bahadur Ali Result Required: C10 = M, D10 = i, E10 = r, F10 =z, G10 = a, <No Space> H10 = B, I10 =a , J10 = h, K10 = a,L10 =d , M10 = u,N10 = r, <No Space> O10 =...

Hello! I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns. This My Table Table Slicers on Excel Dashboards DEPT Column1 Q1 Q2 BONE & JOINT CENTER left without being seen...

We have numerous sheets of thickness readings. They take the form of something similar to: ITEM POS BASE THK BASE DATE THICKNESS DATE THICKNESS DATE THICKNESS DATE 001 A 5.1 11/06/15 4.9 13/06/23 536 25/09/19 5.1 11/06/15 002 B 7.6 25/09/19 8.25 13/06/23 7.6 25/09/19 N 11/06/15 003 C...

Hi, we have the following table where we want some results 1- total count of data (as result sheet) 2-Last date of entry for the product Data SnoDateP CodeC...

When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...

Hi Forum, Hope you can help. I have a worksheet updating every Monday with result from the previous week using VBA and appends to the right of the last entry. When a month is complete I am then required to report the average of the data points - each day has 24 data points for each hour so...