data manipulation

  1. S

    Conditional formatting for individual subcategory ?

    Is it possible to automatically apply data bars to pivot table like this? As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item) To make it more clear on what I mean, here is how it would look like if I used...
  2. A

    Data manipulation help... using pivot tables?

    Hi everyone, I have a data manipulation question that seems simple but I can't figure it out! I have a large list of properties which details how (%) the rental cost (Amount) should be allocated/split between various locations (LOC). The data looks like this: <tbody> A B C D E (D*B) F G H...
  3. J

    Data Manipulation

    Hi Folks! I am back asking for your help. I receive a file in the following format. The rows that start with data in Column "A" are part numbers. Below those part numbers with data beginning starting in column "C" are accessory codes and accessory descriptions, pertaining to the part above. I...
  4. S

    How to make/create OR operator between fields in Power BI ?

    So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...
  5. J

    data manipulation

    hello there guys I'm having trouble passing this data from this format: " Day | 00:15 | 00:30 | 00:45 ... | 23:45 01/jan | 32 | 30 | 40 ... | 45 02/jan | 45 | 50 | 52 ... | 60 " to this format: " 01/jan | 00:15 | 32 01/jan | 00:30 | 30 01/jan |...
  6. F

    Data manipulation to remove undesired character strings

    Hello Mr. Excel experts! I'm in need of help to manipulate a data report that populates the entire information into one cell ("Text to columns" does not work unless there's some amazing trick I don't know how to use). This is a credit card financial statement data. Below is a small...
  7. D

    How to set up qualatative data as a set of binary variables for regression analysis?

    I am doing a regression analysis and have some data from a survey. One column is ethnicity. The way the data is set up is: <tbody> Yearly Salary Ethnicity Age 100 Black 25 87 White 24 57 Black 65 94 Hispanic 45 </tbody> But I would like it set up so that each ethnicity is it's own...
  8. S

    Data manipulation question - simple at first sight, but has me stumped!

    I'm still looking for some help with what at first sight looks like some simple data manipulation but it has me stumped! :confused: I have data on books and authors, like this: Author1 Book1 Author1 Book2 Author1 Book3 Author2 Book1 Author2 Book3 Author2 Book4 Author3 Book5 Author3 Book6...
  9. B

    Copy/Paste Cells based on a condition

    Hello folks, I have the following issue and will be very grateful if you provide some help: I have one sheet which I need to manipulate some data and copy/paste from it (sample below): I need a script which searches for the word 'Open' in column A and next finds the first non-empty cell in...
  10. S

    VBA matching, data manipulation across different worksheets

    I am trying to do an upload to let a general ledger system know when checks are paid (reconciled). To do so, I must upload all checks that are not left outstanding on the bank reconciliation. If a check is on the bank reconciliation, I need to remove it from the Bank History report that shows...
  11. A

    Changing Columns Into Rows with Column Headings

    I want to change columns into rows. I was not able to get in contact with original programmer. This is not for a business, but strictly for my own learning. The before data looks like this. | A | B | C | D | +-------+------------+------------+------------+...
  12. R

    VBA/Macro help needed with combine of rows based - Currently relying on 3rd party addon

    Hi, I really hope someone can help... I have an issue currently that I have overcome with a 3rd party add-on. I am sure there is a way to do this with a macro, however my attempts so far have failed. I am hoping someone can prove the power of VBA and Macros and enable the removal of the 3rd...
  13. D

    Moving Data in Cell

    Hi, I'm currently using excel 2010 & possibly upgrade to a later version in a near future. My question is that I currently have a large excel sheet with data look like below (Please note that the common fields are the member id & dependent associate id): <tbody> member Id name dependent...
  14. Z

    Manipulating Data - newbie!

    Hi all, I have a list of applications listed in columns in row 1. Let's say Column A = Adobe Reader, the rows below it list the users with Adobe Reader installed. I'm actually wanting to have the names in row 1 instead of the application name and list the different applications the name...
  15. L

    Transposing Data

    Hi I need to transpose some data for which a normal transpose doesn't seem to work. The file is available at https://docs.google.com/file/d/0BzsDpPI91t9FMTNRRjQyOFF0N0U/edit?usp=sharing What I want is to transpose this data so that column F becomes a list of the month (as mentioned in row...
  16. V

    Excel 2010 Macro: Manipulating a string of data within a cell

    Hello, I am pretty new to Excel Macros. I've been searching the net and found this forum to be VERY helpful; not quite able to find exactly what I need. My question refers to vehicle fitment for auto parts I have compiled, however need to manipulate the data further. Example (fitment data...
  17. E

    Automating Country Replacement

    Hey there, I'm a student working on some economics research (thus the username) I'm new here and I've been looking through the forums as of late finding some really helpful stuff, but now I'm stuck with the following predicament: I have an excel spreadsheet with all the airplane routes that...
  18. V

    Solution for linking Excel and Outlook

    Hi Guys, I have just started a university society and am in charge of most of the admin. As part of this I need to keep track of members details. Currently we have an entry form set up via Weebly(a website building platform) which allows us new members to enter their details and subsequently...
  19. K

    Arrays or Collections for data manipulation?

    Hi, I have developed a workbook for estimating project costs based on selected Labour, Material, and Plant components, but I've recently dicovered classes and collections and was wondering whether they could be used to develop a more efficient solution. The data is multi-dimensional, i.e...
  20. D

    I need help on what formula to use!!!

    Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data and a button for encoding. Excel WorkbookABCDEF12poducts34date delivered5monthDateYear6location of delivery78delivered by910sales1112Encode13Main...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top