tag:blogger.com,1999:blog-1869924468172210809.comments2024-02-12T12:08:02.364+00:00Not Just NumbersGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger1201125tag:blogger.com,1999:blog-1869924468172210809.post-25666373877416523432023-10-18T00:55:51.295+01:002023-10-18T00:55:51.295+01:00This is a better way: SUMPRODUCT(--EXACT("te...This is a better way: SUMPRODUCT(--EXACT("text", range)) and it works on strings longer than one character, regardless of there in the string the case change might be.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-28559627461932995732023-10-18T00:52:53.041+01:002023-10-18T00:52:53.041+01:00Unfortunately this is of no use if you're look...Unfortunately this is of no use if you're looking for words where the case of any letter might differ. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-46425905244698096272023-05-24T09:39:24.456+01:002023-05-24T09:39:24.456+01:00Well damn - that explains why my spreadsheets keep...Well damn - that explains why my spreadsheets keep getting messed up! Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-83027841133906195062023-05-10T18:23:12.580+01:002023-05-10T18:23:12.580+01:00That's fine if you have control over the data ...That's fine if you have control over the data itself, but if the data is coming from elsewhere, you don't want to have to make changes every timeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-67381183178869927902023-05-10T15:55:26.551+01:002023-05-10T15:55:26.551+01:00Could you not have just CTRL + H > Change "...Could you not have just CTRL + H > Change "h" to "half", job doneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-57923094051126947862022-11-14T02:27:17.200+00:002022-11-14T02:27:17.200+00:00found a tip from other pages that work in our offi...found a tip from other pages that work in our office. for laptop with 2 extension monitors, go-in display setting and set the "scale" to same % on all monitors and restart. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-54183699923529437042022-08-04T16:51:11.298+01:002022-08-04T16:51:11.298+01:00Very efficiently written information. It will be b...Very efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors.<br />MZhttps://www.blogger.com/profile/01831608476491741405noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30329841944753737382022-08-01T19:05:30.994+01:002022-08-01T19:05:30.994+01:00Very helpful and clearly explained. I like that i...Very helpful and clearly explained. I like that it toggles through the optional formatting.Greg Johnsonnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-69087331894917805572022-08-01T19:04:40.580+01:002022-08-01T19:04:40.580+01:00Very helpful and clearly explained. Thank you!Very helpful and clearly explained. Thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-69199881205132137752022-01-18T09:44:24.943+00:002022-01-18T09:44:24.943+00:00It would appear that there are some problems with ...It would appear that there are some problems with the Wingdings font in the online Excel 365:<br /><br /><a href="https://answers.microsoft.com/en-us/msoffice/forum/all/excel-online-wingdings-font-issue/80728e8f-2711-4450-af9e-5d734535e423" rel="nofollow">Excel online issues</a><br /><br />Also, things may be different on a Mac:<br /><br /><a href="https://office-watch.com/2017/inserting-symbols-is-harder-in-office-for-mac/" rel="nofollow">Mac issues</a><br />Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-40281743601825006292022-01-18T05:39:00.262+00:002022-01-18T05:39:00.262+00:00There is no such font in excel how can i get itThere is no such font in excel how can i get itAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-22995628420230373012021-11-22T11:48:00.726+00:002021-11-22T11:48:00.726+00:00Thank you Glen for your helpThank you Glen for your helpKChttps://www.blogger.com/profile/01969707050254531562noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-61965794632800866032021-11-22T09:05:20.067+00:002021-11-22T09:05:20.067+00:00You haven't set the font for the cell to Wingd...You haven't set the font for the cell to WingdingsGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-66760306986962689782021-11-22T09:02:21.971+00:002021-11-22T09:02:21.971+00:00Not able to see the character (thumbs up/down ) on...Not able to see the character (thumbs up/down ) on the excel instead showing "C" and "D", is there any setting need to be changed to see the needed characters? please suggest. thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-58832557816776543312021-11-21T22:57:02.461+00:002021-11-21T22:57:02.461+00:00If this is what you want:
If K36 is 0 or positive ...If this is what you want:<br />If K36 is 0 or positive number then return D36,<br />If K36 is a negative number then return L36<br /><br />Then you need:<br /><br />=IF(K36>=0,D36,L36)<br /><br /><br /><br />Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-87721133771414601852021-11-21T22:13:30.944+00:002021-11-21T22:13:30.944+00:00I'm trying to do a capital gain tax calculatio...I'm trying to do a capital gain tax calculation based on the days in column K26. Strangely its working in some of the cells and not in the rest.<br />If I change the formula to =IF(K36<0,D36,L36) then it works. Not sure what I'm missing, spent a lot of time today in trying different things and reading lot of blogs but no luck.<br /><br />Appreciate your helpKChttps://www.blogger.com/profile/01969707050254531562noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-24140277806848872021-11-21T22:02:39.876+00:002021-11-21T22:02:39.876+00:00Hi Glen thanks for getting back to me.
If K36 is ...Hi Glen thanks for getting back to me.<br /><br />If K36 is 0 or positive number then return D36,<br />If K36 is a negative number then return L36<br /><br />Thank you very much for your help<br />kcKChttps://www.blogger.com/profile/01969707050254531562noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-48971458905927973172021-11-21T21:13:52.119+00:002021-11-21T21:13:52.119+00:00=IF(K36>0,D36,L36) should return D36 if K36 is ...=IF(K36>0,D36,L36) should return D36 if K36 is positive or L36 if K36 is zero or negative. Is that not what you want?Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-68399604149764594562021-11-21T18:38:07.579+00:002021-11-21T18:38:07.579+00:00Hello, Im trying to write an If statement for the ...Hello, Im trying to write an If statement for the following<br />Cell K36 has a number (could be negative or positive)<br />In Column M36 my if statement is =IF(K36>0,D36,L36)<br />This is working when the number is positive however if the number is negative its not returning the right value.<br />Please can you help<br />Many thanksKChttps://www.blogger.com/profile/01969707050254531562noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-83978538308469612532021-07-10T07:29:58.048+01:002021-07-10T07:29:58.048+01:00I never knew that Excel has a baffling array of fu...I never knew that Excel has a baffling array of functions under the heading of "Financial", many of which are only likely to be used by financial analysts. I think <a href="https://matrixcalculator.com/" rel="nofollow">matrix calculator</a> wont be needed anymore.hasnainhttps://www.blogger.com/profile/05845512156979808631noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-6541265417743552542021-07-09T07:55:48.929+01:002021-07-09T07:55:48.929+01:00Unkown - These are the default Excel templates whe...Unkown - These are the default Excel templates where you can change how every new workbook or sheet is formatted. There is a good post here on the subject:<br />https://www.excel-easy.com/examples/default-templates.htmlGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-52731195170953027862021-07-09T00:31:56.300+01:002021-07-09T00:31:56.300+01:00Would you show the complete coding for the additio...Would you show the complete coding for the addition to the format that anonymous added please?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-57145844619865027842021-04-29T07:45:17.073+01:002021-04-29T07:45:17.073+01:00Very useful efforts. Very useful efforts. Marthanoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-50372900251927858162021-01-25T07:20:15.679+00:002021-01-25T07:20:15.679+00:00The simplest answer would be to add another column...The simplest answer would be to add another column with another IF formula:<br /><br />=IF(B14<>"",F14,0)<br /><br />Then sum that column.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-66186342570216380842021-01-24T21:49:57.183+00:002021-01-24T21:49:57.183+00:00I have another one for you after you were such a h...I have another one for you after you were such a huge help. I have column B which receives an x if an order was placed online. I have column F which is the total number of items ordered. What I need is a cell that will add the number in F if there is an x in B but to ignore the number if F if there is no x. I want a count of online ordered items.Cassiehttps://www.blogger.com/profile/06627726673245566405noreply@blogger.com