1px;

Hello, I need help with solving this issue, I want to find and fill data from another row and paste into same column. I thought VLOOKUP could solve it, but it only works "down", not "up". Orginal data looks like these <tbody> ID Grade 123456 123456 Y_15 654321 Y_16 654321 </tbody>...

<tbody> a b c d e 1 1 2 =B1+1 3 =B2+1 4 =B3+1 5 =B4+1 6 7 8 9 </tbody> Hello All! I was wondering if someone could help me with a formula to cycle back to the number 1 after it reaches a limit of 83. I was using the formula above, but when it...

Hello, files with the extension on the specified date need automatic deletion. .csv.pdf.xla.xlam.xls.xls.xlsb.xlsm.xlsx can you help me? ****** id="cke_pastebin" style="position: absolute; top: 72px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">can you help me</body>

Hi first post, so apologies if I make a mistake I need to count the following <tbody> Meter P7 2016 -2017 P7 2016 -2017 P7 2016 -2017 P8 2016 -2017 P8 2016 -2017 P9 2016 -2017 P9 2016 -2017 9761600 165 167 165 217 233 207 212 9763705 237 220 272 240 267 194 9766902 254 245 363 376...

Hi I am looking to take data that is structured in a table and create a spreadsheet with each data point as a row. Example - Start Data <colgroup><col style="width:65pt" width="65" span="4"> </colgroup><tbody> ID 1/25/18 2/14/18 3/11/18 FS01 100.25 98.7 19.07...

Hello I have a big data file in excel with some 'weird' numbers for example: <tbody> 4959,68,4611,9 </tbody> Sometimes it's like this: 7500,7152,22 How can i remove the last commas so that only the first comma will stay? Thanks in advance Regards Wout ****** id="cke_pastebin"...

So I have a list of URLS and I need to return all the related ones into one string. The urls are laid out in a logical manner Domain / directory / sub-directory / In theory this should work, but I'm getting some random urls in there. I just want any url that contains the group slug none others...

Sooo.. I have a ton of data and I need it arranged all by one Row... And using Regex, and custom order, and ascending.. I'm 90% of the way there, unfortunately I'm now kinda stuck, I need to sort like this : <tbody> AAA AAA x2 AAA x5 AAA x10 </tbody> And Excel does this: <tbody> AAA AAA...

Hi I have an excel sheet - Column A contains Phone Numbers separated by a "||" Symbol - Requirement - I want to remove the repeat occurrence of a number with in a cell and retain only one occurrence <tbody> Occurence Post Dedup - Result 18002821376 || 18005675803 || 18002687708 ||...

Hello, In cell E2 I have SESAME NJ 219211550. I am trying to leave the SESAME NJ in cell F2. Any suggestions? ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> SESAME NJ 219211550 </tbody> </body>

hi... trying to make this Lindros Luxur Stairway (11122412) <tbody> </tbody> into a different arrangement 11122412- Lindros Luxur Stairway ... can somebody help use a formula to do this ? the number of digits will always be the same (eight), but the text will vary.

Not sure if that title is the snappiest way to label this query. I have results from a questionnaire which are partly about jurisdictions of interest of businesses. As shown (poorly) below, they way they have been pulled in to excel makes it quite difficult to interact with them. The businesses...

Hi all Wondering if you could help. I have seen other older threads here but couldn't get them to work for me. I have a bank statement I am importing via CSV into Excel. Example data (Sheet 1) is in the following format: <colgroup><col><col><col><col></colgroup><tbody> Date Description...

I'm trying to calculate standard deviation based on multiple criteria. I've used suggestions show on this site and on Google, but it keeps returning the SD of the entire list, not just those that match. Here's the formula I'm using: =STDEV.S(IF($C$2:$C$10=$L2,IF($E$2:$E$10=$M2,$H$2:$H$10)))...

Hi All How do I change 05.11.2018 into a recognizable date format? Thanks ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> 05.11.2018 </tbody> <tbody> 05.11.2018 </tbody> </body>

Hello, Is there a way so that when I copy text from another source and paste it into excel it wont change the font. I know I can do paste special and then quick on text and it will be fine but is there a quicker way perhaps with a formula? I am using Calibri (Body) 12. Any help would be...

Example cell values : <tbody> Demo-PAT-DIRBS-05513-C <tbody> <tbody> Demo-PAC-Center-WirelessService-52515 <tbody> Demo-PAT-SectorSplit-05096-OneCell-C </tbody> </tbody> </tbody> </tbody> I want a formula which will extract only numbers from a cell but it should start counting numbers...

Hello All, I am trying to get the result in column-A and I really need help with a formula to automatically count upwards as I insert data into column-B. In the example below I just wanted to count data "X" in column-B upwards as in our situation, the data has been inserted in the top row as...

I need a formula that compares two columns and tells me if a grade has gone up, down or stayed the same. The table I am trying to populate is similar to the one below: <tbody> A B C D E Grade Year 10 TA4 Year 11 TA1 9...

I'm evaluating a data set of Median product prices against a 100-point product rating scale. The data I have to work with are below. The Correlation of Rating to Median Price is 0.922. Since all of the products rated so far have fallen into the rating range of 87 to 95 I want to predict the...