User Profile
Nicolas94h
Copper Contributor
Joined 8 months ago
User Widgets
Recent Discussions
Conditional formatting - make a cell white based on another cell's specific text "EXW"
Hello, I could use some help regarding my sheet and would appreciate very much if someone could help me. I have the need that every time in for example H3 it says EXW or FCA then I would like F3 to have no color/white. Can any please help with this? Thank you very much in advance.729Views0likes3CommentsRe: Return cells within a specific date range (today-6 weeks ahead)
HelloOliverScheurich, Thank you for your quick answer and your examples. I don't know how to insert an Excel file in my message to you, so I have inserted a picture instead. Please see picture below: I have changed the column order in your Excel sheet to give you a better understanding of how my original table is structured. As you can see in the attached picture above, the dates I want to return are not in the first column. Will this formula still work ? Can you please change the formula? I apologize for the many questions.630Views0likes0CommentsRe: Return cells within a specific date range (today-6 weeks ahead)
OliverScheurich Hello Oliver, Thank you for your answer. You have indeed understood correctly and thank you for showing that it can be done. The only difference is that the column I have the dates in are not in colomn A, but rather colomn J. Can it still be done? See my current formula below: =FILTER(Orders;ISNUMBER(SEARCH(D3;Orders[ORDRE]))+ISNUMBER(SEARCH(D3;Orders[KUNDE]))+ISNUMBER(SEARCH(D3;Orders[[Spærret ]]))+ISNUMBER(SEARCH(D3;Orders[[ETD HEDENSTED ]]));"No Match") Is there any chance you might be able to help me plug your formula into mine above? I am not sure where I should put it. Thank you in advance. I am looking forward to your answer.709Views0likes2CommentsReturn cells within a specific date range (today-6 weeks ahead)
Hello, I have made my own "search bar" in excel with the help of the formulas: Filter, Isnumber and Search. This gives me a dynamic array where it will always update according to my master sheet. But I have the need to search find cells that fall within a specific date range, precisely today-6 weeks ahead. Is there a way for me to be able to find these cells that fall within this timeframe? Where it will also be dynamic and show the whole rows as well. Please help. Thank you in advance.782Views0likes4Comments
Groups
Recent Blog Articles
No content to show