• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Conditional formatting - 200 text values question

    Then if I change the company name, it still highlights the same color as the OLD name even if I rerun the VBA
  2. L

    Conditional formatting - 200 text values question

    Also a clue: it's not the number of cells, it's the number of duplicate companies that cause the formula to stop highlighting. So if I change the company to one of the companies already highlighted as a duplicate, it will highlight in cell 81 or further. So I think the formula needs to be...
  3. L

    Conditional formatting - 200 text values question

    This works using VBA but only up to 80 cells: Sub ColorCompanyDuplicates() 'Updateby Extendoffice 20160704 Dim xRg As RangeDim xTxt As StringDim xCell As RangeDim xChar As StringDim xCellPre As RangeDim xCIndex As LongDim xCol As CollectionDim I As LongOn Error Resume NextIf...
  4. L

    Conditional formatting - 200 text values question

    I am using this formula in my conditional formatting =MATCH(B28,$X$28:$X$28,0) and it works fine for one value. X28 is where I have one value listed. I want to do the same for 200 of these values (I can list them in a row somewhere or column if need be) and highlight the cells in a different...
  5. L

    Help with print format

    This isn't a pivot table just linked.
  6. L

    Help with print format

    Where is that located in Excel? Those options?
  7. L

    Help with print format

    FYI: All of the titles and numbers are linked to pivot tables in other tabs but I have hard-coded everything for the purposes of this question. But need to know that to answer it. How do I lay out this tab better so that I can print and continue the titles on the left? i.e. if the Class of...
  8. L

    General VLOOKUP question

    Okay I fixed that part. Is the formula looking up, for example, A13 across to CR13?
  9. L

    General VLOOKUP question

    Here's a sample file. The conditional formatting for the red text is doing the opposite of what I would expect it to do. The conditional formatting should return FALSE and keep it black, but it turns it red instead. I want it to be red for months after the current month.
  10. L

    Condition Formatting of a separate cell

    Quick question on this as it relates to my q. Somendra, why would it be $L5 and not $L7
  11. L

    General VLOOKUP question

    What would be the purpose of having an absolute cell reference instead of a column number in a VLOOKUP formula? Example: =VLOOKUP(A9,$AC$9:$CR$20,25,FALSE) vs. =VLOOKUP(A9,$AC$9:$CR$20,$CR$8, FALSE) where $CR$8 = 68 and column CR has 1 in CR9, 2 in CR10, 3 in CR11 The conditional format...
  12. L

    Question on conditional formatting

    Thanks, a combination of this and another error I fixed worked! Thanks so much
  13. L

    Question on conditional formatting

    I would but unfortunately it's a work file :/ and it's many tabs that all link together so I can't really modify it to share yet.
  14. L

    Question on conditional formatting

    There are a few rules set up that switch the formatting for our file for every month. One turns the font red. Well, my colleague manually changed the colors to red last month for future months, and now they stay red even though the conditional formatting would say to turn them back to default...
  15. L

    Can you please help with inconsistent formula error?

    The full formula for BU column is...
  16. L

    Can you please help with inconsistent formula error?

    In Tab 2016 Actual, in columns BU, CK and so on, I am getting an inconsistent formula error. I did not get an inconsistent formula error before adding the following to the formula...
  17. L

    Need to add 3rd condition to index/match - I think I am close

    =IFERROR(INDEX(RawData2016[Jan FTE Sum],MATCH(1,($F5=RawData2016[Employee '#])*($E5=RawData2016[Jan Title FTE]),0)),"") To this, I need to add ($B5=RawData2016[Jan Location FTE]),0)),"") but for some reason it isn't working.
  18. L

    Pivot table calculation question

    I don't have access to the raw data just the pivot table.
  19. L

    Pivot table calculation question

    Is there a way to subtract a number from within a pivot table from another number and copy the formula down? It is not working when I try it.
  20. L

    Question on CountIfs

    Hi there, is this a formula I can copy and paste into the other cells? I would like there to be a record of a transfer if it goes from Staff or Senior Staff to Manager or vice versa as well.
  21. L

    Question on CountIfs

    I want to count promotions in certain categories if multiple criteria are met, but NOT count if one cell equals Staff and one cell equals Senior Staff because that is not considered a promotion officially, however since the text is different in the cell it is picking it up as a promotion. I...
  22. L

    Can someone help me correct this formula? Getting Error

    =IF($O73>CB$2,0,(IF(AND(CB73="YES",$M73=""),0.001,(CA73/CG$2)*IF(OR($N73>BM$2,$N73=""),CC73,$Q73)))) I would like to also change the condition so that $M73="" OR >CB$2 So I wrote it like this...
  23. L

    Help with formulas counting

    I need to calculate the days in January not on a Leave of Absence (LOA) pre and post transfer to a new department. The dates of the transfer are given as well as sample LOA dates. Can't get the formulas to work.
Back
Top