Search results

I'd no idea that's what it was called - a cascading drop down list, but now that I know, I can read through these solutions. (y)

So if I had a list of Projects and associated subjects how can I make drop down list for each so I would see a list of projects in one drop down, then whatever I selected for project, it would show only those subjects in the next drop down associated with that project. Here's a small example...

The problem is due to duplicates in our DB. In BO the data is not shown as a duplicate, and in the report I have a date difference days value, which I then sum in BO. When I do this it adds the duplicates in the DB but when I save the data to excel it only adds the value that was shown i.e. the...

One of my figures is 5694 from the database but in excel is 5641, maybe so I don't know? The imported numbers are already whole numbers with no decimals. If I add decimals in excel they are all .00 so there's definitely no extra values hiding in the background. Maybe it's doing something in the...

Version: Excel 2007 Hi I have a report in business objects that I have created as a cross tab with department on one side and sum of item on other side. When I extract the raw data and pivot it in Excel I get slightly different numbers when I sum. If I count the items it matches. The...

Fixed this by putting round((mycalc),0) around the calculation - this takes away decimal place and leaves whole number.

Hi On occasion I have to make a custom column in excel sheet and when I create a pivot and put this column in a filter the filter shows all the data instead of just the distinct values found in the field. Value is age value and cut down the decimal places to 0, but I spoke to someone in work...

Hi One of my work jobs requires me to copy last week's report (with 5 weeks data in them) and then alter it to put in the new week's data. Been doing this since I started and never had this issue before. What happens is I copy the file put in all the data to each sheet, then select all the...

Hi no hadn't tried that - is it specifically for calculations such as this? I eventually found out that there was a template formula for calculating the ratio in the company and got a hold of it. I am not in the office and so can't quite remember it but will try and post it up when I get back in. G

Hi In my data I am trying to calculate a ratio between an old and new value listed in my pivot table. My Data is like this; old new == === 1245 7989 2371 6314 5889 3434 But originally my count of data in the pivot was the two values per row added...

I'll try and post something up this afternoon.

Hi I'm creating pivots for monthly data, each extract of monthly data in it's own workbook. I then create a pivot from that data. In one workbook each row field has a filter arrow next to it allowing filtering of that field, but in my other workbook the first column has a field called row...

Thanks for that Brian very much appreciated. G

Thanks for all the advice I am nowing using datedif() - I can see it doesn't come up in the list in Excel when you type until you put the first bracket in 'datedif(' so initially thought it wasn't in the user functions for Excel but noted it was said that it was still supported.

That should be fine the data is a one off extract that isn't going to change. I will look into what you suggested, Thanks G

Hi using Excel 2007 I have a pivot table and I want to have sub totals for 2 labels that are in the same field. So to explain this graphically I have: City Dept ------ -------- Region Manager 1 Staff 1 Staff 1 Total...

I didn't try that but I tried copying the values into another column and all the values age values changed to 11? Can you explain why use what you have proposed instead, what is the issue?

Found the problem. Should have had quotes round the logic check value: =IF(AH2>"80","80+",IF(AND(AH2<"81",AH2>"64"),"65-80","Under 65")) :rolleyes:

In one column AH2 I have: =LEFT(YEARFRAC(AG2,TODAY(),1),2) Which gives me age in years from the date of birth Then in next column I have: =IF(AH2>80,"80+",IF(AND(AH2<81,AH2>64),"65-80","Under 65")) And for every age it says the range it's in is 80+, even though the ages are in various...

I have a variable in VBA that I populate with the row Id of a particular cell. the code I am using is: UniqueIDValue = WorksheetFunction.Match(wb.Sheets("DataTwo").Range(TargetColumnChar & CStr(i)).Value, Range("DataOne!$" & TargetColumnCharTest & "$2:$U$" & CStr(MaxRowCountTest)), 0) + 1Used...