data management

Ok, this may seem like an odd question - so hear me out please. Currently, we work within an Government client environment which has heavy restrictions on what we can and can't use, or do. Macros are a no go, but mercifully Power Query is ok. The business problem that drives me up the wall is...

The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...

I have cells that look like the one below that contain "Class C Part#:", "Manufacturer", "Mfr. Part #", "Pack code" and "your price". I'm wanting to separate the Manufacturer into once cell and the Mfr. Part # into a different cell. I have about 2,000 of these that I need to do and none of them...

Good evening. I have had a wonderful support with this forum before and thought I would give it another try. I have 10k+ rows of data that includes a client name, score on a specific measure, and the date when the measure was taken. Some clients will only take the measure once, whereas others...

So, I created an Excel Survey to ask new customers to our powder-coating business to provide the vital information regarding their work orders that is badly missed on their hand-written P.O.s, and in the never-ending struggle to make life easier, I thought, "Self, you should really try to get...

Hi, my data looks like this: img upload Downloadable here: Sample data.xlsx - Speedy Share - upload your files here I'm trying to get a formula that does what I did manually in Table 2, Column E. In words: The first table gives me dates of yearly financial reportings per company. The...

I am curious to know if one could create a "management overview" workbook containing live links to various other workbooks. As such, the values on the single management workbook would change immediately after values were changed in any linked supporting workbooks. The tricky part would be that...

I have a spreadsheet of data that runs up to column AWI, with just over 2,500 records. I do not have the option of transferring this data to a relational database, which would be my preference. On any given day, team members need to update various subsets of the data. The most common set runs...

Hey Mr.Excel users, I have been trying all week unsuccessfully trying achieve the following in excel . There is around 1700 unique ID's that I need to do this for so it would ultimately have to be a formula that can be applied to each column. It does not matter which date is populated if...

hi, i have been an assignment by my teacher to arrange data in excel. the data is about some type of customer database which contains ID of Customer, Outgoing calls, Incoming calls and sms, each customer ID Making several calls the data should be arranged in such format Customer ID...