excel help

I have a spreadsheet and it uses when the data imports it displays Ex- ".87 (ft)". having the text and parenthesis in the cell give me an error on the output of the program. There are thousands of these measurements, so I am looking for a quick way to accomplish this.

=SUMIFS('Facebook data'!D:D,A:A,">="&Sheet1!A2,'Facebook data'!A:A,"<="&Sheet1!B2) what am I doing wrong please help

Hello, I have a doozy here and any and all help is truly appreciated. I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date...

Hello, I'm breaking my head here, I understand a little =Tex which changes my TODAY() cell in another cell to 0406. Now I would like to add initials at the front like CS0406 followed by 6 random numbers. CS0406123456- It's killing me, can someone help? It doesn't have to pull the date from the...

Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...

Greetings all! I am a new member to MrExcel Discussion Boards, but have relied on your wisdom for years. Unfortunately, I came across an issue that I cannot find a solution to, and I have tried searching everywhere for an explanation. I will try explaining as best as I can, please let me know...

With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...

Hi, I'm having a problem with a specific issue and looking for help, i'm not a excel expert, so please explain in layman's terms. Setup I have a set of randbetween 1-100 in A1:A100, then in Column B1:B100 1 to 100 in sequential order (1,2,3,4,5,etc...), in Column C1:C100 a formula (A1*B1...

I have a data validation drop down that chooses a range beginning with =Today() and then goes out 7 days. When tomorrow rolls around the worksheet requires you to go into the data validation drop down and select today's date. As the data validation box does not auto-refresh. Is there any way to...

Hello I need help and not able to find my solution. I have in a sheet called TOC on cell J33, which updates every 2 minutes based on a = function to another sheet that uses a api query. My goal is to track last value (history) before it updates, and have the data output on another sheet...

Hi Experts, I would really appreciate some guidance as I cant quite figure out what formula to use. If this was already answered previously, I cant seem to find. I Already spent hours on forums and youtube videos. Perhaps I am wording my question wrong? I have thousands of rows of ITEM #'s...

<tbody> Rule Born Trigger Variable XYZ Texas Texan A or B or C or D ABC New York New Yorker A or B or C or D RST RST A or B or C or D WXY WXY A or B or C or D DWF DWF A or B or C or D </tbody> Hello I need help with this excel formula. Basically I always have data in Rule column...

I am trying to remove items from my catalog that are discontinued. I added the column of new P/N so I can match it up with my current catalog to quickly identify those products. Those that are not highlighted should be the discontinued items. However, I see P/N that are highlighted when there is...

I am new to using excel for charting. I was asked to prepare charts or tables that will effectively answer the following questions: Of the subsectors noted in the table, which produced the highest number of fatal claims in 1990 – 2014 for: · Pneumoconiosis (make sure to include...

I have 3 sheets of data. Sheet A: Has a drop down list with statistics (checks, sales, items) which drives the data on sheet C (see below). There is also a graph on this sheet that is based on the data on sheet C (see below). Sheet B: Has all of the raw data that the workbook is based on...

Our customer numbers begin with A followed by four zeroes and a string of numbers. Example: A00002121256438 A00002178164211 A00002191112936 A00002152291978 How can I create a formula to remove the 4 zeroes following the letter A so that the...

Hi mates. I'm working on a file where data is entered date wise and I need to keep a track of the latest date entered besides the last order received. When I'm using Vlook up, it shows the date which is on the top of beside that wendor's name but not the latest. As the latest date is mentioned...

Hello, I have PDFs that I converted to excel. The PDFs contain a Subcontractor, General Contractor, and then every invoice#, invoice date, and invoice amount that that subcontractor has paid. When I convert it to excel the data all gets listed in one row. I would like it to be listed vertically...

I am trying to calculate IRR on a one time transaction as follows initial investment $6.1 Million Return captured 120 days later $17.5 Million our investment partner has an IRR threshold at which point we receive an equity claw back and higher percentage of the proceeds. I am having...

I would like to have a formula to round off an amount in a personalised way. To illustrate, if an amount comes to 830.70, then the amount will be rounded off to 830.00, but if the amount is 831.40 then it will be rounded off to 840.00. Which excel formula shall I apply to get desired result?