Dec 29 2021 01:10 AM
I am facing the issue regarding Bold text in formula's & Subtotal in Table
the example file link is on one drive. due to issue of attaching in this dialog box.
Dec 29 2021 02:23 AM
Dec 29 2021 03:38 AM
sorry jpg is also not attached
so i update it mediafire link
https://www.mediafire.com/file/du2lkgp1x91a0cp/sample+file.xlsx/file
Dec 29 2021 04:25 AM - edited Dec 29 2021 04:29 AM
As far as I know (even if that doesn't mean much :) in formula you can't format parts differently.
But you can do it with VBA code.
1. Start the macro recorder
2. In a cell, select only the text that should be bold
3. set the bold attribute for the selected text
4. Press the Enter key to complete this process
5. quit the macro recorder
Now you have recorded the VBA code and can adapt it in the VBA editor.
...Or split it into several cells and format the relevant content accordingly.
Insert subtotals in a list of data in a worksheet
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Dec 29 2021 10:27 PM
Dec 30 2021 12:10 AM
The formula for the subtotal is available in your sheet (Cell E70), you only need to insert a filter in your table and the subtotal is automatically counted.
=SUBTOTAL(109,[Amount])
The formula for the subtotal is available in your sheet, you only need to insert a filter in your table and the subtotal is automatically counted Enclosed the file as it is, only with additional filters, you can filter as you like by column and only the filtered one is counted, or if you do not filter the total sum.
Thank you for your understanding and patience
I wish you much success in your project
NikolinoDE
I know I don't know anything (Socrates)
Dec 30 2021 01:06 AM
Dec 30 2021 04:02 AM
=SUM(SUBTOTAL(109,E7:E69,M7:M69))+0*NOW()
Existing area in your file: E7:E69
Imaginerer second area: M7:M69
The additional expression "+ 0 * NOW ()" always causes a recalculation of the two functions carried out if something changes in the worksheets, especially if the F9 key (= recalculation) is pressed.
Thank you
Nikolino
I know I don't know anything (Socrates)
Dec 30 2021 09:17 PM
Dec 31 2021 01:05 AM
I don't see a file and still don't understand what exactly your plans are, or what / where / how exactly is to be accomplished.
Once I set it up as I understood it, the translation doesn't help much either. The file is inserted.
At the same time, with your permission, I would like to point out that knowing the Excel version, operating system and storage medium (fast disk, OneDrive, sharepoint, etc.) with the inserted file (without sensitive data) and / or photo are always very helpful. Helpful for you to get a quick and precise solution proposal and the time spent by the helper is invested in the solution and not in guessing.
Meanwhile, wish you a Happy New Year ... or days with lots of joy and health.
Hope this information could help you.
I know I don't know anything (Socrates)
Jan 03 2022 10:11 PM