raw

Hi, I have a multi-tab spreadsheet in which I pour in raw data to a raw data tab and in my main view tab I see the data points I care about from raw data in vLookup. The problem is that the number of rows is inconsistent. One week I could paste 150 rows while the next I could paste 180. To be...

Hi there, I have a multi-tab spreadsheet where raw data is dumped in a "data sheet" tab on a weekly basis. This data is pulled into the "main view" tab. I'd like the "main view" tab to always reflect the same data in the first column as the first column of the raw data tab. Initially I set it...

Hi guys, I am new here and starting to learn about macro. Currently I would like to create a macro that enable me match the value that are the same (only numerical and ignore the +/- sign) and highlight the value that are same in yellow. For example, I have 2 worksheet. One is the actual and...

Hi, I am a beginner at excel. A number of months ago I created an excel file, used for sorting quantity data. The first sheet is used for importing (pasting) the raw data. This raw data is then sorted into other sheets depending on the "Product Type" column. I have since introduced two new...

All, I am using the below current formula in an attempt to get the Average Time to Fill for a specific range of numbers: =SUM(M3+M8+42948)/+(N3+N8+358) BUT what I really want to do is get the Average Time to Fill using the following data: =SUM(QTR1_TA_TaleoData!U4:U170) PLUS the...

I am contacting the forum today in search of some advice/help or solution to a problem which I'm pretty sure is being caused by the size of the data I am using and what formulas I am trying to utilise within the sheet of data. In Column H of my report (this report is 50,000 rows long) is column...

Asking for a friend who works in an organisation where there are some challenges in terms of providing raw data to non IT people... Seems the preference is to centralise requirements in IT with "programmers", ques and an output which is somewhat limited in functionality and usability...

Hi folks, 1. My spreadsheet contains a mix of raw data (transactions) and formula. I would like the formula to automatically apply as soon as the raw data is pasted in, so I have pre-dragged them down to the 15,000th row ... is there a smarter way of doing this? 2. I made a Summary sheet which...

Hi all, I have a dynamic pivot tablet that uses data from our accounts package that is manually replaced every few days. As it changes, i use the following: =OFFSET(DATA!$A$3,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$3:$3)) Initially it worked fine but for some reason now, it is not picking up the...

Worksheet "Transport Summary" cell B1 will be the lookup value. My lookup data resides on a worksheet called "Raw Data", columns A-C I need to look up the value in cell B1, then look on the worksheet "Raw Data" to find all the matching values as in B1. Once found copy data from columns B and C...

Hi I have a tabel in power query excel 2016. In this query I have a tabel like this under here. My question is, is it posible to split the A column so it will look like the second tabel under here? In my tabel I have many other coulums to, like Amount, Restamount and som others, but this is not...

hello, dear, I have excel macro enabled worksheet and i uses filtered raw with start A5 to R5. means 18 standing line in my excel.o.k. I want that if i filter C5 than C5 will change either color or font style etc. If i filter D5, than same thing do. so that i can easily find that which raw...

hello , im hoping i can get some advice on a problem i have. I need to be able to add a simple <p> tag to specific points in my text in excel cells. so for example some of my cells have product descriptions liek this Goodio Raw Chocolate 56% Coffee 48g x 15 Starring sweet, smooth and...

I'm having a hard time figuring out what i need. I have two sheets one with Raw data, then Results On results page i have name column then resolved and then Open. I want to have the results look at the name column and search on the Raw data sheet on column G the name column and count how many it...

<tbody> A B C D E F G H 1 Ravi Ravi 2 mahesh mahesh 3 mahesh Kalpesh 4 Ravi 5 Kalpesh 6 Ravi 7 Ravi 8 Kalpesh 9 Mahesh 10 11 </tbody> The 'A" raw has a name of people. I want the name in "F" raw...

Good morning! I need help with my table. I have two lines (Raw Score and Relative Rank): <tbody> Raw Score 390 100 660 350 310 Relative Rank </tbody> And I need the second row to list the numbers from highest to lowest. <tbody> Raw Score 390 100 660 350 310 Relative Rank 2 5 1 3...

So I have come across a pretty tricky situation. Here is the question: This is part of a much larger issue but I have taken out a sample. I have two worksheets as you can see attached, one is for auditing and the other is where I input raw data. What I need to do is to match date and the title...

Hey all, I've got another slight query: I have this code: Sub Copy() Application.ScreenUpdating = False Dim wkbSource AsWorkbook, wsDest As Worksheet Set wsDest =ThisWorkbook.Sheets("SMART Raw Data") Dim lColumn AsLong lColumn = 3 Const strPath AsString =...

Hi guys, I want to replace below characters in first raw in range("I3:P52") into those in second raw. Could you pls advise if there is an fast and effective way to do so? As you can see the range is 400 cells altogether. ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ...

<tbody> A B C D E F 25 10 0 250 60 125 7 500 100 336 33 600 369.25 1425 526 181 </tbody> I want A x B = answer in two raw ( last 3 digit n "F" and first any amount digit in "E") what can i do ? pls help me