Forum Widgets
Latest Discussions
- KofC9282Jan 13, 2025Copper Contributor11Views0likes1Comment
FILTER problem in Excel 365
I am facing a filter problem. - I have created a table called Table_1. This table is on the tab TABLE In addition, the filter below is on the SEARCH tab =ALS.ERROR(FILTER(Table_1;NOT(ISFOUT(FIND.SPEC(A1;Table_1[Name]&“*”&Table_1[Zip Code]&“*”&Table_1[City] )))); “Nothing found”) Unfortunately, I get a return message ifl I search in a programmed search field for, say, PLACE OF RESIDENCE the message #Overflowing! in Dutch #OVERLOOP! In addition, I cannot center the text in the SEARCH FIELD vertically. For that, all options in the TAB START are all in gray; NOT available to make changes. I don't know now what I am doing wrong. Can you help me? Thanks for any suggestion.ArendJan 13, 2025Copper Contributor7Views0likes1CommentFormula Help Required - Packaging Spreadsheet based on Type.
Good Morning, I am struggling to create a formula to provide a total weight for a packaging spreadsheet (Image attached). I need to create a spreadsheet which provides total weight depending on a part number and the packaging specs. I have packaging types and the relevant weights. Then dependant on the part number I have a qty of packaging. For reference, Part number A1234 uses packaging type H, height 1. This means I need 1 H Lid, 1 H Pallet and 1 H Collar. The formula needs to see the packaging Type H then use the weights in this type based on the packaging qty? Please can anyone provide help on this?ElliotDTJan 13, 2025Copper Contributor20Views0likes1CommentExcel noob needs help ><
I'm wondering if it's possible to take every 1st and 2nd row data but skip the 3rd row into a formula on a separate sheet. https://imgur.com/a/3EOEvrS Taking A13 A14 data skipping A15 and repeating the pattern and then putting the formula into this sheet: https://imgur.com/a/IviFwWZ under B13 B14 B15 ect.. Any help would be wonderful!!! ThanksMitch09Jan 13, 2025Occasional Reader11Views0likes1CommentConditional Formatting (CF) being 'ignored'... by ONE cell in a Worksheet!
I have a Worksheet where Conditional Formatting (CF) is set so that any cells with a (currency) value that is 'equal to or less than £0.00 (GBP)' are hidden - by setting the Font & Fill colours to White. Each day, new data is added to a Row - one Row for each day of the year. So far there is one cell which is ignoring the CF, displaying a value of £0.00...! I have attached images showing the 'offending' cell & the corresponding CF - I even added a CF rule for the specific cell, but it is still being ignored! Any suggestions or help would be appreciated. If you need to see the CF rules for the whole Worksheet, or the formulae applied to any/all cells in the Worksheet, let me know. TIAUKdeejayJan 13, 2025Copper Contributor6Views0likes1CommentGraph Not Updating with New Data
I'm using the Personal Budget Template that comes with Excel. When I create a copy of the Current Month Tab and input new data into the Current Month (2) tab, the pie chart does not update correctly. Only the column chart updates correctly with the newly input data. How can I fix this?OnJan 13, 2025Occasional Reader9Views0likes1Commenttest
Data was exported from one server and has to be imported into another server. The servers accept the information but it has to be re-formatted to be accepted and not throw errors. The down load server export sheet contains a cell of information that will not be accepted by the upload server. It has the header "ITEM SPECIFICS". It generates two columns of data (left & right) the left is the data title or data term. It is followed by a ":" The right side is the associated tombstone data. It is followed by a ",". The column has over 100 terms. If there is no associated data with the term, the ":" is immediately followed by a comma ",".Cannnot_Sign_in_everJan 13, 2025Occasional Reader3Views0likes0CommentsCovert Value into text formula
i want to covert an figure into inr text pls help me to provoide formula9058344031Jan 13, 2025Occasional Reader3Views0likes1Comment- Cannnot_Sign_in_everJan 13, 2025Occasional Reader5Views0likes0Comments
Need help with calendar formula
Have a calendar by month, has a formula to calculate the dates on previous month (and same for the next month). I must have deleted a reference cell by mistake. Appreciate help fixing the small 'previous' and 'next' months (January '25 and March '25 in the image)sheilam30Jan 13, 2025Occasional Reader6Views0likes1Comment
Resources
Tags
- Excel41,972 Topics
- Formulas and Functions24,325 Topics
- Macros and VBA6,323 Topics
- office 3655,894 Topics
- Excel on Mac2,603 Topics
- BI & Data Analysis2,311 Topics
- Excel for web1,865 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,601 Topics