I now want to automate the creation of the table but don't know how to reference the [@[Account ID]] or [@Date]). So far everything I have tried results in the cell being blank Dim lastRow As Long lastRow = Cells(Rows.Count, 2).End(xlUp).Row Ran...
Dear Manoj Patgar, (1) The problem has been posted on the forum by Reuben Helder because the formula using nested If functions is not adequate, due to its limitations. The number of items in the text list is large (Sales, Arch, Land, ALL, Contracts, Construction and po...
Hello, I am currently preparing a payment milestone template which also records the last/latest date of payment. I used the this formula to do just that, =LOOKUP (2,1/ (J4:LN4<>"",$J$2:$LN$2)). B... MrNobody, as variant you may expand your LOOKUP with one mor...
{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1733913106917,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject...
Hi Team,Greetings! Hope everyone is safe and doing well.I am new to excel and learning few of its functions/formula on daily basis. I need help on below...
Which would simply return "Yes" if the cell contains the name Daniel, what I dont know how to do is to replace the "Yes" for a formula that would give me the "RED" in return. I know the formulas Left, Mid and Right are probably the way to go but since the s...
Yes, from my numbers list i would like select numbers in patterns like these 1133322 1133323 1133332 1211113 1222213 1222223 1222231 1222232 1222233 1222333 1223222 I played with the formula that you gave and could filter and select some numbers with necessary patterns. for instance i ...
Try this. It is an array formula that has to be confirmed withCtrl+Shift+Enter. With a value such as 12ABS34 in A2: =MAX(FREQUENCY(IF(ISERROR(-MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),ROW(INDIRECT("1:"&LEN(A2))),IF(ISNUMBER(-MID(A2,ROW(INDIRECT...
I have column G with either the word"filled" or "unfilled" in it. I want to add a column that returns the value in column F if column G contains "filled" or nothing if it contains the word "unfilled... Juliano-PetrukioThank you it appears to have worked. I was putti...
Hello, how are your? I will try to help you with the following If(G2="filled",F2,"") Paste this formula and fill down as per your needs. That is good to hear from you. If you feel that I deserve, please hit the Like button....