Forum Widgets
Latest Discussions
Plotting date and time on the X axis
I have variables on the Y axis that I want to plot against date and time of day. My data input format is mm/dd/yy hh:mm (10/30/24 20:47). When plotted on a line chart, all of the variables are shown on the same date regardless of the time. How do I get the chart to show the time of day?phowellNov 07, 2024Occasional Reader0Views0likes0CommentsOverwriting the conditional format of a cell
Hi. In my spreadsheet I have already set up a conditional format to turn a cell red if "Labour" has been entered in to C2, this turns L2 in the sales percentage column to red. What I'd like to happen is if I then type 0% in L2 then it turns green. My format formulas are- =C2:C76="Labour" turns L2:L76 red. Works as it should. This is the one I can't get to work- =AND(C2:C76="Labour",L2:L76=0%) I'd like to turn the cell green. Any help would be greatly appreciated. ThanksSolvedHotfuzz38Nov 07, 2024Occasional Reader40Views0likes8CommentsPower Query - removing identical generic text from the start and end of multiple columns
Hi all. I am after a hand in removing some default system values from a Jira export that I am using to build a report around. When multiple values are recorded in the system, a new column is created in the export and number is appended to any duplicate columns example"Label" and "Label2". I previously received assistance in understanding the code to merge the values in these columns and rename them, thank youLorenzo.For any columns that have required merging, I have been able to address their naming as part of the process, but I have multiple columns whose headers still require attention and can be handled as part of a grouped transformation process due to each containing identical redundant values. When a custom field is created, Jira wraps the value with "Custom field (" and ")", for example "Custom field (Country of Origin)". Some of the headers have valid values contained within brackets, so I can't simply replace all brackets - I have tried using the"Custom field (" as a string to identify relevant headers to useText.Start(_,Text.Length(_)-1) to get rid of the trailing bracket andthen Text.End(_,Text.Length(_)-14) to remove the leading text... but ended up with a list of correct headers but no data. Clearly out of my depth but felt frustratingly close. I also attempted to useList.Transform(Table.ColumnNames( )and removed the leading text and bracket... but then couldn't get rid of the trailing bracket. I had a fair crack at it today but haven't managed to get it to do what want and now my brain hurts, so have created a very simplified version of what I am trying to do and am seeking your help. In the Output tab of the sample file, merging of columns has been completed and I would like the columns Custom field (Weight), Custom field (Organic (Y/N)), and Custom field (Multipack (Y/N)) transformed into Weight, Organic (Y/N), and Multipack (Y/N). I am after a solution that searches for and replaces text in the headers rather than explicitly referencing column names as the export's contents are variable and dynamic in nature, and there are far more of them. Thanks in advance🙂🤗Insert_KeyNov 07, 2024Brass Contributor385Views0likes20CommentsCreating Automated Amendment/Edited Date
Hi There All Just wanted to see if it would be possible to create an automated amendment date on multiple sheets. There are multiple people that edit these shared documents and I would like to see when it was last edited by someone. If this is possible could you please help me out with a solution!GriffinmonNov 07, 2024Occasional Reader8Views0likes1CommentFilter Function based on checking group of raws
Hi I have 1000 raws. I want to use the filter function to check if there is data in each raw to return the corresponding value. It is not worthy to write the filter function like this: filter(A2:L2,(A3:L3)+(A4:L4)+(A5:L5)+(A6:L6)+(A7:L7)+(A8:L8)+(A9:L9)+(A10:L10)+........) Is there better way to prepare a function for this purpose?I want to use this function in google sheet see the attached file ThanksSolved19Views0likes2CommentsExcel forms and VBA
Hello Was trying to do a button, which will open excel form (feature in excel for data entry and tables) So basically when i run the macro , which opens shows this form, the form is not workable, i cant enter any data ,this is how the form looks (below image) MY vba code for the form is this , what is wrong with that? is this form not designed to work with vba and automation and this is the investment table am trying to fill Thanks for any suggestions, if anyone encountered such issuechahineatallahNov 07, 2024Copper Contributor112Views0likes2CommentsInput 1 to 7 SKU numbers to return groups of rows.
My actual document has 300 cases of product listed in rows, I trimmed it down to 20 cases of product for this example and replaced the names for confidentiality. I want to be able to input these three components 9800006353, 9800006357, 9800006356 and return rows 3-6, 12-15, 24-27. Because the Case SKU in column A has more than just those three components. I want to be able to do this with any of the hundred or so components exist and then return the Case SKU with all of the Component rows. First image is what it would like to start with, then I would input the three components 9800006353, 9800006357, 9800006356 and the second image is what I am looking for. Second image below.robodan70Nov 07, 2024Occasional Reader29Views0likes2CommentsExcel VBA
good morning guys , my name is Logan. I am new to this community and also new to the whole excel VBA thing. I need your help in a project I am working on which is basically spreadsheet with 2 tabs (Database and Reports). what I want is automation of the process report capturing from the Database sheet within the specified Dates when "generate report button" is pressed. like for example: if the diagnosis is malaria , designation is GPOC ,age group is above 5 years and type of visit is a new visit then update the circled cell by adding 1. this goes for the rest on the listed diagnosis. and thanks in advance.34Views0likes1Comment
Resources
Tags
- Excel41,526 Topics
- Formulas and Functions24,037 Topics
- Macros and VBA6,239 Topics
- Office 3655,788 Topics
- Excel on Mac2,568 Topics
- BI & Data Analysis2,268 Topics
- Excel for web1,835 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,576 Topics