# Activity Stream

• Today, 03:12 PM
Bob, Consider sending some fake data and will will assist
1 replies | 45 view(s)
• Today, 01:28 PM
something like this? If not let me know and will finesse. Source data should really be a table and remember to refresh PVT is you change that raw data
1 replies | 19 view(s)
• Today, 01:11 PM
Ken Here is a quick and dirty, not fully clear as to what you exactly want... reach out to me if you want this finessed/radically altered ...
3 replies | 66 view(s)
• Today, 12:47 PM
Hi All, I have small query in pivot tables. i have created the pivot table and now i want to have differences between the columns. Please refer to...
1 replies | 19 view(s)
• Today, 11:34 AM
This =M4=SUM(\$J\$4:\$K\$4) works for me if I understand what you are trying to do correctly. Paul
1 replies | 22 view(s)
• Today, 11:13 AM
I am trying to use the formula to highlight field green if(\$M\$4=SUM(\$J\$4:\$K\$4)) it read if m4= j4+k4 but keeps bringing up error
1 replies | 22 view(s)
• Today, 11:12 AM
jonespandrew replied to a thread percentages in Formulas
Thanks I have sorted it
4 replies | 56 view(s)
• Today, 09:49 AM
Paul_Christie replied to a thread percentages in Formulas
Try =IF(B2/A2<1,(B2+C2)/A2,IF(D2="",B2-C2/A2)) where A2=805, B2=803, C2=2. I'm not quite sure what you are trying to achieve with IF(M3="".... in...
4 replies | 56 view(s)
• Today, 06:28 AM
AliGW replied to a thread percentages in Formulas
So if you want the cell to show 100% regardless of the real value, why not just type 100% in the cell? Sorry, but I don't understand what you are...
4 replies | 56 view(s)
• Today, 01:38 AM
jonespandrew replied to a thread percentages in Formulas
issue 1 =IF(I3/F3<1,(I3+M3)/F3)IF(M3="",I3-L3(/F3) i can get the green part to work but not red part help
4 replies | 56 view(s)
• Today, 01:02 AM
jonespandrew started a thread percentages in Formulas
Hi can anyone help with these 2 issues. 1. trying to get a fourmulae to do the following in one cell Total issued Total Passed missing...
4 replies | 56 view(s)
• Yesterday, 10:50 PM
I'm not trying to manipulate the Pivot Table at all. I have attached a file that I made as an example of what I'm looking for with comments to better...
3 replies | 66 view(s)
• Yesterday, 07:50 PM
HI, I checked several pages to know avail, I would like to display an Icon (The shapes set) in one cell based on the % value from another
1 replies | 45 view(s)
• Yesterday, 07:12 PM
Perhaps you can add a calculated field to the Pivot table that sums those 4 categories for each company, then you can use GetPivotData on that new...
3 replies | 66 view(s)
• Yesterday, 06:48 PM
Hey everyone! Need help with this task... My main question is: Is there a formula that can return the company with the highest total sum of multiple...
3 replies | 66 view(s)
• Yesterday, 06:41 PM
try a user-defined function:Function blah(LookFor, LookIn, Output) x = Evaluate("IF(" & LookIn.Address(external:=True) & "=" &...
4 replies | 96 view(s)
• Yesterday, 03:06 PM
Actually I figured it out. Upon opening of userform, unprotected, then protected on close. Thanks though.
2 replies | 51 view(s)
• Yesterday, 02:49 PM
Any chance of attaching your (de-sensitized) workbook and code ?
2 replies | 51 view(s)
• Yesterday, 01:22 PM
Just to back up NBVC line of thinking I noticed that KUTOOLS seems to have the functionality you are looking for and it may be safe to assume that...
4 replies | 96 view(s)
• Yesterday, 01:09 PM
I would like to thank anyone in advance for help with my problem. I am using excel 2010. I have a table that data is added to by a userform. On...
2 replies | 51 view(s)
• Yesterday, 01:00 PM
You'll probably need a user defined function (VBA function). If you google CONCATIF or Concatenate with conditions, or similar you will find many...
4 replies | 96 view(s)
• Yesterday, 12:47 PM
You sent me a PM (which included a file that I took to be data-sensitve) on 17th of this month to which I replied on the 19th. If you were to answer...
9 replies | 458 view(s)
• Yesterday, 12:36 PM
I see a few people have viewed your post but not yet coming forward with an answer. I thought I'd post a quick response to let you know that we're...
4 replies | 96 view(s)
• Yesterday, 08:34 AM
Hello, I'm new to this forum and would really appreciate some help. I have a spreadsheet with 10,000 rows. Some of the cells in Column B are...
4 replies | 96 view(s)
• Yesterday, 08:18 AM
Can someone look into this please? Thank you
9 replies | 458 view(s)
• Yesterday, 12:37 AM
Hi nangys, Have a look at the attachment file and tell me, is that what you want? I used my function to unpivot multi level headers. Look at the...
3 replies | 347 view(s)
• 2017-06-21, 07:20 PM
Hi Dan, Thanks for looking into this. I didn't expect it was going to be that complex! Nangys
3 replies | 347 view(s)
• 2017-06-21, 03:00 PM
No idea I'm afraid. I don't have a version or PC that allows the use of the Data model/Power Pivot.
3 replies | 131 view(s)
• 2017-06-21, 02:59 PM
better to use double-click how about in the cell you double-click ? Try experimenting with this in the sheet module Private Sub...
1 replies | 87 view(s)
More Activity