Search results

prabirmustafi ... You asked something but You thought something else ... You got something instead that something which You thought. Even minor differences could make huge differences. Did You get an idea? Your My question is if I change the value in cell A2 from Stage 1 to Stage 2 then the...

prabirmustafi Here one sample version. This take care Data Validations too. Your sample data's COMP-columns has spaces in cells which looked empty - try to avoid that. You skipped to write about those borders ... I coded my version for those.

kmkmahesh What is missing from my sample? Did You find differences with Your give results? Maybe sometimes it would be good to try to use something different too. I tried to offer something, which can help everyone. If You would like to use only formulas then Okay, please continue using formulas.

Hunter Childress In this thread below You means ... You @Hunter Childress Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker. If you do cross-post, please put that in your post...

kmkmahesh I'm getting different result than You. I offer something else than formulas for You. You could add there as many rows data as needed ... and press [ Do It ] You can see and learn my result right side of that sheet. (( If SLOWER cell is green then You'll see ... how those result will...

ah_mktanlys_01 1st file - if max one data per cell then it should work. 2nd file - macros have to be enabled if You want to use it. This file should save in local disk. ... Here that sample data file.

It's not better, it's different.

About Your: My goal is to make Excel insert the cross marks as shown in the columns that indicates with whom the action is right now. Columns H, I and J. Why do there missing one crossmark?

Okay ... You skipped to check and verify based Your #6 writings. If that is correct then why did You skip to crossmark third With Us?

sveinhelge.urdal Did You check and verify Your thinking?

DiHa9 As You've read ... Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker. If you do cross-post, please put that in your post. Also if you have cross-posted and get an Solution...

Yes ... You did those Yourself. I try to ask other way... How did You know to which cell You mark those crossmarks? As I tried to ask in #3 reply - did You check Comments and after that You marked those crossmarks?

A sample file.

Alina_T I used VBA for colors too.

MeMikeExcel You could study this eg from: https://www.thespreadsheetguru.com/listobject-tables-vba/ or https://stackoverflow.com/questions/49774855/vba-delete-visible-rows-after-filter-applied

sveinhelge.urdal Do Excel make those the cross marks base Comments? ... eg Not issued by Originator makes mark to With Originator.

soul1974 I asked / wrote: Are those realistic / correct / verified / expected result based Your file? You wrote: Hi, it does work for me. Thank you for the assistance. You mean that Your file's example which has 70 serials gives totally 134 ... for You, it works... I would use something like...

ah_mktanlys_01 If it needs to be a formula and each cell have max one data then write to cell B9 =FILTER(SocialData[Service Line - Content Abbr.],(SocialData[Start Date]='SOCIAL CALENDAR'!B$7)*(SocialData[Facility]='SOCIAL CALENDAR'!$A9),"") and copy as it needs. Take care that columns keeps...

Alina_T It would be good to read always all texts. In some cases there could be something which You should know too. I noticed that previous version has one line which should modify - delete Your previous version and use this one. # Drive ... okay .... Did You write that 'minor "Drive" detail'...

blb Isn't this ... same as Your previous thread https://chandoo.org/forum/threads/conditional-formula.56734/ ... same file with same writings which seems have something mystic?

soul1974 Your I just changed it manually, for example. If You're showing something for example then even those should be realistic. Are those realistic / correct / verified / expected result based Your file?

Alina_T Did You notice my the last question? Here one sample as I tried to offer. # Use spinner to select year # cell H1 for selecting month # cell J1 for selecting number of months to show (1...12) # there are different colors/rules for some different cases

There are in two cells words return, which one You're trying to calculate? Which one do You mean? Suggestion ... something like with Your previous threads solution.

blb Are You details correct & verified? Check this ...

matt-gilbert # Those works with $O$3 too, because You have values only in one Commodity in time; checks $/unit -columns. p45cal # case empty or zero eg row 8 has values: 3.1 / - / - / 2.3 my version min gives 2.3 (as expected) , but I would like to show it as zero same kind of case is with...