Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Prominent Member
Joined: Dec 7, 2016
Last seen: May 29, 2025
Topics: 8 / Replies: 967
Reply
RE: Calculation for Average Cost & Cost of Holding

Hello, I am not sure I understod this correct, I have followed the instructions but am far off from your wanted value. Do check if this is usable o...

11 months ago
Reply
RE: Duplicates

Hello, You can use =SUM(COUNTIF(A1:A17,B1:B17)) to sum the duplicates found in column B. Br, Anders

11 months ago
Reply
RE: AVERAGEIFS with multiple conditions

Hello, In your sample data you have no T1 discount factor below 12, that is why you get the #DIV/0! error. You can use IF or IFERROR to handle such...

11 months ago
Reply
RE: Dropdown list

Hello, Check out the blog article Dynamic Dependent Data Validation to see one way to get what you want. If you need hands on help, please uploade ...

1 year ago
Reply
RE: Is there a hotkey in excel that is equivalent to the in-formula "F2" hotkey in google sheets?

Hello, The closest you get (as far as I know) is to use CTRL + [ to go to precedent cell or CTRL + ] for dependent cell. The shortcuts are for thos...

1 year ago
Reply
RE: TIME

Hello, The numbers in F and G columns are just decimal numbers, not treated as time. Replace the comma with a colon and you will get the time value...

1 year ago
Reply
RE: Filter names by Highest Value and classification

Hello, See if attached file works for you, using INDEX, SORT, SEQUENCE and FILTER functions. I haven’t checked for tie amount values, might need ad...

1 year ago
Reply
RE: How to get the Text of Stock Names?

Hello, Unfortunately, no file attached. Br, Anders

1 year ago
Reply
RE: vlookup between two workbooks

Hello, I would use Power Query to combine the data, but only so if it is a recurring task. There are lots of tips and guides in the blog section. I...

1 year ago
Reply
RE: Auto Fill Text

Hello, You do probably have the advanced setting set to show a 0 (zero) for null values. If not, please share your file (do remove sensitive dat...

1 year ago
Reply
RE: LastStatus: Return value for most recent (3 criteria)

Hello, I assume you have Excel 365 and thus MAXIFS function. Try with following formula: =MAXIFS([Status],[Exercise],"*"&[@Exercise]&"*",[N...

1 year ago
Reply
RE: Conditional Formula Scenario: Date is before TODAY & Adjacent Cell does not equal "Complete"

Hello, You can skip the IF function, go with =AND(H9<TODAY(),I9<>”Completed”) Br, Anders

1 year ago
Reply
RE: Excel Python

Hello, You will find the answers in Microsoft support page Get started with Python in Excel. In the How to use Python in Excel natively blog post y...

1 year ago
Reply
RE: Overlapping dates and times

Hello Robert, You didn’t complete the formula correct. Check out the blog post for this. In the attached file I have partially corrected your fo...

1 year ago
Reply
RE: Paste Special not available

Hello, Check if this info at Microsoft Learn is of help. Br, Anders

1 year ago
Page 6 / 65