excel & formula

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

Would you know what is the correct match function with wild card. I have three sheets in one work book. They all do not have the same product description, all three sheets have the same header columns. I tried to use sheet1 and sheet two for the cell match Total (Qty) from both into Sheet3...

Hello, I have a problem to solve regarding placing the orders for materials before the material runs out from the stock. for example in the image below, row 2 shows the demand per week of part x. Row 3 shows the stock inventory after consuming the week's demand plus the shipment received in that...

This is 2nd Friday of Feb. Date: 2/10/2023 Returns First Friday of the current Month. =WORKDAY.INTL(TODAY()-DAY(TODAY())+1,1,"1111011") What formila will tell what friday it will land on. (Want the formila to tell me if it will land on 4/7 or 4/14. The correct date is 4/7) I could create it...

Good afternoon all. Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in. As you can see below - A, B and C all share the same data and i need them merged into...

I'm a little stuck on a project. Sheet 1 has a list of people Sheet 2 has a list of people Sheet 3 needs to compare the lists in Sheets 1 and 2 and list the differences between them. I'm not sure of the syntax, and how to write the indirect formula to do this ? Any help would be greatly...

Good afternoon, I am in need of a formula that will identify the month name in one column from the month number is another column. To be specific, I need the "MONTH" column to show the abbreviated month name using the number in the "MONTH #" column. Any help would be greatly appreciated...

is it possible to convert a excel value from date number to date via vba or formula where the input is 1 to 365 and leap year 366 to a output of month and date number for example 104 as date number and date for 2023 will be april 14. i couldnt figure out how so i haveno code to start with whatsoever

Hello, I want to merge two columns - column R and column S. Few data is in column R and few data is in column S. Is there any way or formula to merge the columns?

In the column A there are data. I'm asking for advice. I need to extract data between two expressions in a string and the condition is met that three lines in a row contain: 1st line "<CATEGORY_ID>" 2nd line "<CATEGORY_NAME>" 3rd line "<CATEGORY_FULLNAME>" AB1<SOMETHING>4562<CATEGORY>Snow...

Hey guys, Struggling here with a big project of mine and really need some help! So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not. Column b provides me with my trees data tag. i need to find a way to...

Hey Everyone I've been trying to figure out how to write this formula and I'm open to using VBA if need be but I'm super new to it so my knowledge is limited. Summary: I'm trying to get CELL = [sheet2] X but if X is Blank then CELL = [sheet2] Y, if Y is Blank then CELL = [sheet2] Z, and if...

Dears, I need a "conditional formatting" to get highlighted if all the information are matching in all 3 tables like in the sheet.