solved

Hi folks. Here is my scenario I'm trying to sort with using only formulas (older external program will not read .xlsm or .xlsx). I'll spare you the details of my own hackneyed attempt but let's just say I felt I was getting close with INDEX, MATCH, FIND and VLOOKUP but hit a wall. Columns A...

Hi All, Problem/Headache: I am trying to apply some sort of conditional formatting based on a cell value however, I only want the formatting to affect the corresponding cell to left or right not the whole column. Not sure if that even made sense, sorry if it didn't. . Example: In B1 I have a...

Hi All, I have been working on a workbook to manage the cases my office manages. The most important part of this is managing contractual timeframes and this is what the workbook is based around and so most formulas are simply IF workday functions with some edays and network days thrown in for...

Hey all, I need help with a data transpose. If you check out what I pasted below for the first data set, you will see that I have columns for different attributes and values. Some attributes appear in different columns and their values are always to the right. What I want to do is transform...

I am having an issue manipulating a flat file. I sometimes have values in extended columns, rather than below onto the next row. How can I shift/offset these values to the rows below. I have 2 grids below, one with an example as it is now and another of what I would like to occur. The values...

I would like to refine my Lookup function from using static values to computed ones. The function in question takes the value of a cell (in this case A5) that is given in raw bytes, and converts it into a more human readable format (e.g. 1.46KB, or 2.06GB rather than 1500, or 2211908157)...

Greetings! As the title states, I was searching around the web for a simple code to do this, there are some already, but, none fully satisfied me, so I did a pretty simple one to achieve this, hope it helps someone :) Function CreateSheets(NameSheet As String, Optional Looked_Workbook As...

Hi, I've created a spreadsheet for my football team and need a little help on two of the formulas, that I wish to put into my spreadsheet. Example below: <tbody> A B C D E 1 Home Name Home Goals vs Away Goals Away Name 2 MFC 7 - 2 CFC 3 Northern Monkeys 3 - 1 MFC...

Hi there, Thanks for spending time considering my problem, I'm new to VBA (and not familiar with coding in general).. Anyway, my company wants me to create a VBA macro in order to export some columns of a sheet into a CSV file. (with semicolon separator) This CSV file will then be used to add...

Hi, (I've gone through a lot of threads and couldn't find a similar question) I work with numbers split into "Units" and "Baskets". 24 Units = 1 Basket Can a formula convert (e.g.) 25 units into 1 basket and 1 unit. 42 units into 1 basket and 18 units 420 units into 17 baskets and 12 units...

Hello saviour I'm a bit of a novice in excel and have been racking my brain and the internet on this one. Here's the data set <tbody> B Rain days C Apr D May E Jun F Jul G Aug H Sep We 0 0 Th 0 0.2 Fr 0 0 0.8 Sa 0 0 0.3 0 Su 0 0 3.4 0 Mo 0 3.4 0 0.8 0 Tu 10 0.4...

Hi, I have a spreadsheet where I need to input people's basic data (e.g. name, address, town, zip code, etc.) Is it possible for the "Zip code" cell to be automatically filled by referencing a list on another sheet of the Excel workbook once the "town" cell has been entered? For example, if I...

I'm trying to make a collection out of a list of items in cells. Each cell may or may not have a few items separated by ","'s... I've got that part down...At least I think... but then I get to line 9, my DontDupe collection is empty... I expected it to possibly just hold the last added...

Hi everyone. One of our partners don't understand how to usefully present data, and their equipment is generating data usage reports into csv/xls, however are displaying data values in a mix of GB's, MB's and KB's. We need to sort and compare this data, and its absolutely useless in this...

Can't really find an answer, perhaps it is not possible? I am trying the following in VBA. I have a range A1:AB10 (rng1) on sheet1 (always the same size). I want to copy that and transpose it and place it in sheet2 (rng2). Then the loop runs again and I am then going to copy rng1 again...

I think I may have made my last post to complicated and confusing. I'm going to try and break down the issues one by one and hopefully I can get some help that way. Here is a link to my other thread if you care to look at what I have done so far and what I trying to accomplish...

Good day all! I am trying to enter a formula in a workbook that pulls it's data from other multiple workbooks. When I hit 'Enter' I am getting a pop-up box telling me the formula has an error. This is the formula...

I need to insert a "," or a "space" into the following formula so I can space out the results from each cell. ="CDS RENTAL CATEGORY"&CHAR(10)&" ["&F28&F29&F30&"]" I would like the result to read F28, F29, F30. Currently they show up as F28F29F30 Thanks in advance

I have been reading and trying and trying and reading and searching and I cant figure it out. I'm no coder, obv. I made a checkbox form that when initially is checked, via macro it filters a pivot table and pivot chart. I made a macro to undo this procedure once the box is unchecked but it...

I have a project in which I am needing to determine if a form has yet to be completed. On one tab, I have a list of all assigned ID codes (referred to as 'All' tab). On another, I have a large running-list of the completed ID codes thus far (referred to as 'Dataset' tab). I have used this...