formula & text

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

I have gave this a good bash and got close but struggling as it is text. So here is the problem. Col A and C are working great. Col. A = dropdown options (15ft basket, 10ft basket, 30ft pipe) Col B = 15x8x4, 10x4x2, 30x1x1 (Dependent on col A selection). Col C seems to be working fine with...

Hi I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows <tbody> Col A Col B Col C Row A Q1 5 1 Row B Q1 2 Row C Q2 1 1 Row D Q1 6 1 Row E Q4 3 </tbody> In my spreadsheet I have to repeat...

Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...

I'd like to update a string of numbers and add charters before each string of numbers. IE <tbody> 006-01-00-00 R006-B01-S00-P00 006-01-01-00 R006-B01-S01-P00 </tbody> :confused:

I have a lists worksheet with an account listing in A13. In my Master worksheet I have an account column with that account name in cell A18. In the details page that account doesn't display in the accounts column I entered =Lists!A13 in cell A18 on my Master worksheet, the account name went...

Hi, So I am trying to create a Fantasy Football spread sheet. I want to create a formula that will read the team name in the cell next to it and then spit out the bye week that team has assigned. For example if E4="ARI" then I want F4=8 for their bye week being week 8. While it is easy to...

Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...

I've been having a hard time finding a solution for this problem I'm having. On Column A is a name of an edit to a certain set of drawings. The drawings are on Row 3, starting at Column E (ie: E4) and the symbols found on row 4 signify which of the drawing sets have the latest revision...

Hello! I just signed up and this place looks like heaven to me right now after hours of sweating and crying over this spreadsheet. I have data for thousands of people. The people all have a name, listed in column A. Then in column B is the date at which they logged their weight on an app. In...

Hi, I am having troubles combining different cells into 1. Here is what I have so far. <tbody> Lesson Study Learning Study Action Research Video-based Research Learning Circle Combined 1 1 1 1 1 1 1 1 1 1 1 </tbody> So far I have used index match and vlookup for combined...

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

ok so I'm trying to organize some data but when i paste it from elsewhere i can post it but I can't seem to find a way to organize it. I ave to do hundreds of these and I'd prefer to not do it all by hand so if anyone knows a way of organizing these with a formula that would be marvelous! this...

Hello all, I'm fairly new to Excel as a whole but am looking to learn as many tricks and tips as possible so I thought I'd come to the appropriate place to start asking questions and learning! Thank you in advance for any responses and please let me know if I can provide any additional...

I am trying to get an if statement to sum based on certaincriteria. I have attached a screen shot for better understanding. Essentiallywhat I want to achieve is this. In my screen shot Cell U4 is the sum of CellR4:T4 This is fine but what I want to incorporate is that if Cell O4 contains"yes"...

Hello all, I am a total newbie in Excel but I love it and I usually am able to do simple things just by trying until I get it, but this time I am completely stumped as nothing I try works. I will explain why I want to do what I am asking, but if you are not interested feel free to jump to the...

It would be helpful if you can find a formula for these lines. <tbody> Date Particulars Amount Result 2/1/2016 SB-TRANSFER 44342960 SB REF. 7038594 B/O NETWORK INTERNATIONAL LLC NI POS SETT 010116 109866251 Value DATE, 02/01/2016 - S11702254 619.6 109866251 2/1/2016 SB-TRANSFER 44342961 SB...

Good afternoon Guys and Gals, After some help with a formula to count specific cells starting with a particular three letters. In example: IF B3 Starts with EXP***** Count. Thanks in advance! Dan

So I'm familiar with with many methods for converting text to numbers on a vlookup error. I normally use either the past multiply (by 1) or the paste add (by zero). However, this didnt work this time around. I had to use ALT+AEF (the delimiter route - and it worked). Fine and dandy but I...

I am trying to write a formula that if text matches that from a list in one cell that the result in another cell replies with text from another list ex. if sheet1 a1 contains = junior and hello is in a list on sheet 2 a1 then sheet1 b1 replies with jr from list on sheet 2 b1 im trying to use...