User Profile

Abiola1

MVP

Joined Oct 07, 2019

941 Posts124 LikesLikes received48 Solutions

View All Badges

User Widgets

Recent Discussions

Re: Changing Column Width is not an option - way to unlock?
Right-click on the column and select Column Width. The column width isn't disabled. You can try another worksheet or workbook
Feb 17, 2021 Place Excel
445Views
0likes
0Comments
Re: Excel Formula
Hi, I perceive you're asking Excel to do the impossible. You can only have one formula in a cell irrespective of how short or long the length of the formula
Feb 17, 2021 Place Excel
2.9KViews
0likes
0Comments
Re: Using the =PROPER(text) Function
PROPER function should work pretty fine. Let say you have DONE in cell A1. In cell B1, enter =Proper (A1) and hit enter. It should deliver Done in cell B1 I suggest you close your Excel workbook and reopen and run the formula. Cheers
Feb 17, 2021 Place Excel
936Views
0likes
0Comments
Re: Counting function depending on color
https://m.youtube.com/watch?v=bfAzXwcS8G8&t=238s
Jan 25, 2021 Place Excel
2.4KViews
0likes
11Comments
Re: Lambda function is missing on Excel Insider Beta
Though, I have the LAMBDA, you're not the only person that haven't gotten the function yet. Flighting on Beta Channel is usually the first 50% lucky subscribers. It takes some time for it to get to 100% flighting to Beta Channel. Then, it takes another time to light to Current channels etc
Dec 08, 2020 Place Excel
9.4KViews
0likes
5Comments
Re: LAMBDA Function
As Sergei rightly said, the LAMBDA Function is currently available in Beta Channel of Office365 and M365. A video of the LAMBDA Function in the link below https://youtube.com/watch?v=LmhtiB3b6lQ&t=19s Cheers
Dec 08, 2020 Place Excel
1.5KViews
0likes
0Comments
Re: LAMBDA Examples: Distance between two cities
LAMBDA👍😃:bottle_with_popping_cork::popcorn::party_popper:💥
Dec 04, 2020 Place Excel
34KViews
0likes
0Comments
Re: @line graphs on excel
Hello, Though, I can see your data however you can watch the short youtube videos to guide you in creating single line chart https://youtube.com/watch?v=3PwVWX28dEE https://youtube.com/watch?v=Pq9UNX55R8U Do let me know if this helps Cheers
Nov 08, 2020 Place Excel
685Views
0likes
0Comments
Re: Cell references
In Sheet2, enter this formula =IF('Details'!C11:C20="","") You can copy down the formula using fill handle For the IF False, you can put in whatever result you wanna see if the logical test is false
Sep 30, 2020 Place Excel
846Views
0likes
0Comments
Re: copy and paste
Hello, Kindly check the link below to see whether it answers your question https://support.microsoft.com/en-us/office/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6. Cheers
Sep 27, 2020 Place Excel
1.2KViews
0likes
2Comments
Re: Fuzzy lookup
No code can perform that... The add-in has to be downloaded and installed to perform Fuzzy matching. Cheers
Sep 21, 2020 Place Excel
3.3KViews
0likes
0Comments
Re: Fuzzy lookup
Alright. That's a different case.. But, if you need the add-in on your personal system, you can always download it. Finally, if the Fuzzy Lookup is essential to what you need to perform your job, why not speak to to the IT department in your office and explain the need for you to be allowed to download the add-in ? Cheers
Sep 21, 2020 Place Excel
3.4KViews
0likes
2Comments
Re: Fuzzy lookup
Hello, You should be able to download the Fuzzy Lookup add-in from the link below https://www.microsoft.com/en-us/download/details.aspx?id=15011
Sep 20, 2020 Place Excel
3.9KViews
0likes
5Comments
Re: Excel - How to add header and footer in Exdel for android?
Hello, Headers and Footers are available on Excel Desktop. Not available on Tablet Regards
Sep 20, 2020 Place Excel
9.6KViews
0likes
1Comment
Re: Single column against multiple rows
Hello, You can use PivotTable to analyze the data.. Click inside the data and select Pivot table under the Insert tab..
Sep 15, 2020 Place Excel
733Views
0likes
0Comments
Re: How do I convert HH:MM:SS to a numeric value
Hello, I believe the post in the link below answers you question. https://www.ablebits.com/office-addins-blog/2015/07/01/excel-convert-time-decimal/ Kindly go through it.. Regards
Sep 11, 2020 Place Excel
39KViews
0likes
0Comments
Re: Unfreezing Excel Columns of data
Hello, The Unfreeze Panes in the View always work.. Don't know why it doesn't work over there. In addition, when you click on Unfreeze Pane, it removes the freeze pane from your spreadsheet. If you want to Print columns B,C,D and E for instance, you will need to select all the data in the range you intend to print and then deploy CTRL + P. In the Print Preview, choose selected range and print... Cheers.
Sep 11, 2020 Place Excel
959Views
0likes
0Comments
Re: Data Type Stocks not working in Excel 2019
Hello, You can actually use the function in Excel for the Web, free! All you need a outlook or hot mail email address which you can to access Excel for the Web. Regards
Sep 11, 2020 Place Excel
47KViews
0likes
1Comment
Re: An excel workbook turned off my auto-save, how can i enable it back?
Hello, Same question was posted in the link below and possible solution provided. https://social.technet.microsoft.com/Forums/en-US/b944ff41-e965-497a-a30f-10a20e07d37d/autosave-turned-off-this-workbook-contains-features-that-prevent-it-from-using-autosave?forum=excel Do go through the link and follow the solutions provided. Regards
Sep 11, 2020 Place Excel
8.1KViews
0likes
0Comments
Re: Excel 2019 one-time purchase license
Most likely, the laptop you handed over at the store will be formatted and the installed office will be out. There is not alternative way to sign out without doing so on the laptop. You can still sign in with your Office version 2019 credentials on your new laptop and transfers your documents there for continued use. Cheers
Sep 10, 2020 Place Excel
2.8KViews
0likes
0Comments

Recent Blog Articles

No content to show