formula & text

Good afternoon, I believe this is quite a niche and complex ask and not sure if it is possible. I have 2 workbooks which will be called "Workbook 1" and "Workbook 2". Workbook 1 has items that I am trying to input into Workbook 2. I want to be able to read "MD500" from Workbook 1. "MD500" is...

Hello, I have a formula question about a excel. In my new sheet i plan to track my spare part contracts. In columns "N" i want to express the stadium in which the project is, as you could see in attached photo. Instead of writing the state manually i want formula to do it for me. I looked up...

I have following data for Latitude and Longitude with its coordinates and want to transform the value (LT and LG) as per below. for example S.no >383> 19.159314 to 21 : 8 : N and 77.313188 to 75 : 16 : E rather than a long coordinate numbers. These numbers are extracted from...

Hey guys, bit of a tricky one here and would love some help, will try explain as well as i can. In the cells below i have A1-C3, A1 tells me if the action has been completed, No means it hasn't and so no. B1 tells me the device used C3 tells me the product The formula i am after will...

Hello This should be pretty simple Data inserted Common Data Formula 4.00 whatever =A2&B2 I wanted the results in C2 to be : "4.00 whatever" but result will be "4 whatever". The data inserted in A2 is with the ".00", it's not the excel cell format.

Hello Guys, I need excel formula for my below problem. Here, Step involved: I need "Total Cycle Time". 1) When we click the cell "No of items produced", it will ask me to enter Quantity 2) Once I enter "No of items produced" (B2) ( it will calculate the cycle time according to the below...

Hi, I need a formula that can get the characters in between the ( ), is there any recommendation? Here's the a sample table: Current Name Results AA BB (227501AA) 227501AA A BBD (227501BA) 227501BA AAC BBS (CC7501AA) CC7501AA AA DDAA (117501AA) 117501AA Thank you!

HI All What I want to do is take the cost price of B5 ($788) add the gst of cell P3 then add the labour amount of P5 and then add on the markup % of cell P4 & show the new amount in C5 which should be $1575.18 ABCDEFGHIJKLMNOPQ12CostNew Price3GST10%4Mark Up35%5$ 788.00Labour 13006$...

I am trying to get color combinations for various product types. I have the following two columns: Product Colour Product A Blue Product A Yellow Product A Pink Product A Green Product A Orange Product B Yellow Product B Green Product B Blue Product B Pink Product C Blue...

Hi Would you be able to assist me with dates in excel sheet ? I need to creates formula in the grey filled cells. It is to monitor cash flow and when money is due in. Based on the work dates column A&B I need formula in columns P,R,T etc through to BF to show the sums which are portioned to the...

I have a cell with a long text string. I need to count how many times the value "004" (quotes included) shows up. I tried the search function, but it doesn't work with quotes. Also, it will only tell me if "004" exists in the cell, not how many times "004" shows up. Any help would be so...

Can you please help me find a way around Can't figure out why this one working: {=COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1))} Which evaluates in something like COUNT({2,4,6,2}). And it results in 4 Now I want to count only 2. So I use...

Hello, Can you please help me find a workaround to load needed records Is there a way to replace #REF error, but keep #VALUE one ? Or in other way, Is there a way to load #REF records , but exclude #VALUE ones ? If it helps I use the following formula in order to find keywords. And result...

Hi, Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/ What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and...

Is it possible to Sort excel in multiple columns when there is a formula in each column's cell? I was trying to Sort using Data >Sort and noticed that when I chose column Sort by - Column C it doesn't change other cells (ex. A, B, D & E) accordingly. Please note - Cell A contains Name like...

Would like a formula which would extract the contents between the word circuit and the second comma in a string: MPLS - MPLS Services, Circuit 2083676, Verizon, xxxx,,xxxxxxxxxxxxx , xx MPLS - MPLS Services, Circuit 572222DAT1, xxxx,xxxxx,xxxxx

Hi, Please HELP! I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell. TAB 1 (ColumnA) (ColumnB) <tbody> Name Amount Anne OFF Amy Mike Doe OFF Anne...

Hi This is the problem. I have a column with something like the following: Column B Line 1 SS 2 d' FS 0 d Line 2 SS 5 d' FF 6 d Line 3 FS 0 d Line 4 FF 0 d' SS 3 d' FS 0 d' FS 0 d' SS 3 d' FF 11 d' And so on each line can be and is different. What I need is all the...

Hello Team, Need to look for "AA" in the Text and if so update the Yes in result , for those multiple invoices if the Text is also not equal to "AA". i have trying with below formula, but stuck: =IF(AD16="AA","Yes",IF(MATCH(J16,$J$16:$J$22,0),"Yes","No"))...

Hello Excel friends, I'd greatly appreciate help to learn how to do a couple of Excel tricks. The 'Data' sheet contains a single column A which houses the data in <Sheet1!B:B>. I'd like the chart to always display the x-most recent quarters of data, x being $C$2. If it's possible, I'd like $C$1...