User Profile
Ilgar_Zarbaliyev
MCT
Joined 6 years ago
User Widgets
Recent Discussions
Re: Formula with Multiple Date Ranges
Atira_Syafiqah_7393 Please find solution below: =IF(AND(A12>=DATE(2022, 3,2),A12<=DATE(2022, 8,3)), "Chair",IF(AND(A12>=DATE(2022, 8, 4), A12<=DATE(2022, 12, 9)),"Table",IF(AND(A12>=DATE(2022, 12, 10), A12<=DATE(2023, 4,4)), "Glue", ""))) Sample file is attached to this message. I hope it will help you.31KViews0likes1Comment- 1.8KViews0likes0Comments
- 1.9KViews0likes2Comments
Re: Date/Time Stamp a Changed Excel Entry
This is how it should be, because the Now function is a Volatile function. As time changes constantly, the Now function will also change constantly. Changes in any cell of the Tab (Worksheet) you are in will update the Now function. As far as I understand, you want the date of the change to remain constant. Right?6KViews0likes0Comments- 1KViews0likes0Comments
Re: Sum up customer specific costs from another table
Hi there, It would be better to have excel file itself. What I would like to ask is related to Excel version which you use. If this version is 2016 and previous ones, you may use CSE (Control+Shift+Enter) combination for Array Formulas.1.5KViews0likes1CommentRe: Retaining (or fixing) conditional formatting
Monodon Hi there, I just tried to understand the issue: 1 - You wanna to copy your file where conditional formatting applied. To do so, use Paste Special from where, first select, Format, Then Formulas or Values. Everything remains the same. Regarding colors, make sure that you use the same color pattern (Page Layout - Colors). 2 - If you want to divide table where Conditional Formatting applied into some tables based upon on Months, so Conditional Formatting range should be changed in each table manually. Once again, I answered based upon on the level of my understanding. Good luck.1.1KViews0likes0CommentsRe: Excel, Formulas and Functions
AFatria Hi there, To be honest, I tried to understand your query. As far as I understand, you want to add word Generic to each row of I Column where we see Vlookup function results. From other point of view, there is data validation on I column. So, I added word of Generic to N column using &. The solution is attached to this message. P.S. Of course, there are other ways to solve this problem, however, If you found my solution satisfactory, please highlight it. Thanks in advance.2.3KViews1like1Comment
Recent Blog Articles
No content to show