TableI want excel to display the following: Count the number of rows with a date filled in when a cell from one table is equal to a cell in a different table column. For example, With R9 containing the value 8 and column A having many 8’s, I want excel to count the number of… Read More COUNTIF two indexes match to return counts of their rows
I have a tables of companies with attributes and attributes weights like this: attr_1 attr_2 attr_3 attr_4 attr_weight 1 2 1 3 attr_1 attr_2 attr_3 attr_4 result company_1 + + + 4 company_2 + + + 5 company_3 + + + + 7 So how can I connect attributes with their weights to be able… Read More Excel dynamic attributes weights
I have a few cells with numbers: I gave them the number format #.##0 "Mio. Liter". So, for example the number 8145369 becomes 8.145.369 Mio. Liter: However, the cells just show Hashes: When I hover a cell, the correct format (8.145.369 Mio. Liter) is shown in the hover info. How can I show the numbers… Read More Userdefined number format in excel shows just hashes
The aim of my work is just to save multiple Excel Macro files with exactly the same name. I used the openpyxl library for it. The only thing, which changes in my file is the number att the end. My code looks as follows: from openpyxl import Workbook, load_workbook wb = load_workbook(‘Collections/Collection Note – 001.xlsm’)… Read More Excel file corrupted after bulk saving with Python
I have an excel workbook with many sheets which I would like to add into one big csv file using Python. I have written the below code which currently only adds the final sheet’s data to the csv. How do I refactor this so that ALL the sheets in the workbook are being added/appended to… Read More Append many xlsx sheets to a csv file
I want to pick out “Month/day” from string like “2023/7/13 0:31:19”. I tried to it by using a function,LEFT() and RIGHT(), but it didn’t work. For example Number A B 1 2023/7/13 0:31:19 RIGHT (A1,5) I guessed B1 would be “31:19”,but it was practically “76852”. Please tell me how to pick out. >Solution : Try… Read More How to pick out dates. In Excel
Can anyone help with this? I want to create 3 new columns from the data pulled in the fifth column that separates the numbers from the dashes. So for cell containing "54-9-24", I need 3 new cells with 54, then 9, then 24. NA >Solution : Or as follows: For the leftmost number: =left(F2,find("-",F2,1)-1)*1 For… Read More Splitting up Values in the same cell in excel
Given a spreadsheet where we have columns as follows: A, …, P, …, S, … Test1, …, Name1, …, Test1, Test2, Test3, … Test2, …, Name2, …, Test3, … Test3, …, Name3, …, Test1, Test3, … I would like to create a list of values from Column P where A is in the list S1.… Read More Concatenating multiple cells in one column based on condition on list of strings in another
I have some data that is in this format: Position 2012 2013 2014 1 A B A 2 C A C 3 B D E Is there a way to plot this data? The way it is set up is that the table is sorta like a line chart, I know its weird but that’s… Read More Plotting some data in a weird format in excel/python
I have an excel table with 2 columns of data. A GL account and a cost. I’m trying to return a single calculated cell with the criteria being a selection of GL rows based on a middle 4 characters within the GL code itself. The result is then to SUM the cost for these selected… Read More SUMIF with MID Criteria