thought

I have done all of my 2018 budget projections for a accounting firm and looking for Dashboard ideas. Can anyone help. Just looking for something I have not thought of yet.

Hi, Is there a way to get some kind of dynamic conditional formating: if A1 = B1, then A1 formating =B1 formating (font and text color). I thought of a macro on a change value event but I miss the "undo" function. Any idea? Thanks in advance

I am looking for a way to file through thousands of lines of data and to pick out certain duplicate items. I feel like I am just spitting out all of my thoughts, but hopefully someone will understand the gist. Using this table as an example, the thought train goes like this: 1. Check if column...

I have a large spreadsheet w/ over 8000 lines. I want to create 15 different worksheets (1 for each supplier) is there a way to automatically do that? I have been copying and pasting. I thought there might be something in subtotal - like at every change in vendor, create new worksheet, but...

I'm trying to do something like calculate(sum([amt]),[s]<>a||dimension[doc]<>b)). It seems so straight forward, but then maybe I need a fake dimension table for the fact column I'm filtering on. Before I implement a dumb solution like that, I thought I'd ask to see if maybe my syntax is just...

OK before i give up is there a way to print the width of this sheet that it will show columns A thru Q, and its 200 rows down, I can't figure out anyway on how to print this file, some help would greatly be appreciated. i cant send sample excel sheet i thought i could. Thanks

Hi, First thing thanks for looking at this, its appreciated. I am trying to count how many cells are equal to 1 when they match a date. So in the example below, I want to see how many 1's there are for the 17th July 2017 for each shift pattern. http://prntscr.com/ghpypb I thought this would...

I want to basically be able to use the remainder as a whole number. So I may have a problem that is 277/10 = 27.7 So my remainder is .7 , I want to be left with only 7 I need to be able to take any remainder and subtract it from 10 So if my answer has a remainder of .7 I need to be able to do...

I have a worksheet of data coming in from access to excel in the following way: <colgroup><col span="4"></colgroup><tbody> custid name home_branch type 189 AnyName 19 MTW25 189 AnyName 19 ROMEX11 189 AnyName 19 CUWIRE9 </tbody> <colgroup><col...