Search results

I think the yellow on right is actually more correct. The data name "12356" has two options, 400 and 500. So, for each of those OP, you need to list out all 6 files associated with "12356", right?

@delta Please remember that while it's certainly and allowed and encouraged to post the same question on different forums (aka cross-posting), we ask that you provide the links to the question, so all may see if the question has already been answered...

If position doesn't need to change, there's no need to use a graph. Let's just use your hand image and some floating text boxes. In the attached, you can see where I calculate the percentage, build the label text, and then linked it to the floating text boxes.

Updated with an error trap for when value isn't found.

I'm afraid I'm confused as well. Can you try explaining the whole process that formulas should be doing? I.e., "If there's at least one "sell" value in col D, then take cells F4:F28 and multiply by 5"

Glad you liked it. The names are shown using custom data labels. https://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/ So, once you've calculated the position using XY coordinates, I have the chart show data labels. There's add-ins to do this, or you can do it manually by...

Somewhat related; for those of us who post on multiple forums, often dealing with different languages, here's an online formula translator I like to use (also handles the comma -> semicolon issue) https://en.excel-translator.de/translator/

See attached. Formula uses INDEX and SUMPRODUCT.

Here's a function (UDF) that will do it. You could then call if like =CountShapes(A:C) Function CountShapes(rngSearch As Range) As Long Dim sh As Shape For Each sh In rngSearch.Parent.Shapes If Not Intersect(rngSearch, sh.TopLeftCell) Is Nothing Then...

@RAM72 You have cross-posted again, directly after Hui telling you not to do that. You've also stated a new question in an old thread. Please take a moment to review the forum rules before continuing. Then, open a new thread with your question (and provide links to cross posts) Cross post...

@Kushi Krishnappa Thanks for visiting the forums. Note that a polite forum behavior is to notify people when you have posted the same question on multiple sites, known as cross-posting. You have posted this same question here...

In a helper column put this formula: =TRIM(A2) and it'll automatically remove preceeding / trailing / extra spaces.

You've got the RangeMasterOne range defined as a SUM, rather than just the range of cells. In Details workbook, RangeMasterOne should be defined as: =Master.xlsx!Table1[[Words]:[Description]] and then the VLOOKUP will work.

Here's the code you could use. Sub MakeRows() Dim lngRowNum As Long Dim lngRowCount As Long Dim ws As Worksheet 'What sheet are we dealing with? Set ws = Worksheets("Question") With ws 'Load our variables lngRowNum = .Range("E2").Value...

You're formula is missing a comma separating the test condition from the True argument in the IF function. ="Q" & CHOOSE(MONTH(A2),4,4,4,1,1,1,2,2,2,3,3,3) & IF( MONTH(A2)<=3,"FY" & " " & (YEAR(A2)-1) & "/" & RIGHT(YEAR(A2),2), "FY" & YEAR(A2) & "/" & RIGHT((YEAR(A2)+1),2) ) Fix that, and your...

Your AdvFilter macro isn't working, because the criteria column headers don't match. Cell T6 has value of "Due", but label in O6 is "Due In".

Can do this with an array formula. See attached.

Hi Anatha, Please take a moment to review the forum rules. You have cross-posted your question w/o providing links to the other sites, which is a direct violation. Other posts: Replace text in email body from the excel...

Mike, glad you liked it. Looks like John beat me to the answer. Cheers!

Welcome to the forum! :awesome: Looks like a simple change to the formula in col C to not give a number when not needed. In C2, put: =IF(OR(B2={"Ready","Resolved","Moved"}),"",NETWORKDAYS.INTL(A2,TODAY(),1)) Then copy down as needed.

As a start, you could have a formula like this in H2: =COUNTIFS(B:B,B2,F:F,F2,C:C,C2)>2 It's checking to see if the same travel authorization had matching employee/approver for more than 2 of the 4 items.

@adamuce Please take a moment to review the forum rules. While we don't mind cross-posting answers, we do ask that you provide links to avoid wasting time across different sites. Thanks.

Right on! :cool: Glad you liked the post. :)

Cross-posted here: https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1197691-multiple-worksheet_change-macros-in-one-workbook https://www.excelforum.com/excel-programming-vba-macros/1214552-multiple-worksheet_change-macros-in-one-workbook.html

mq1973, this is your 2nd warning about cross-posting. You have previously acknowledged the first warning. Please take a moment to re-read the forum rules. Acknowledgement: https://chandoo.org/forum/threads/index-with-sequential-criteria.36836/#post-221098 Cross-post...