Forum Widgets
Latest Discussions
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.
Formula 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?
Excel 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!!! Thanks
Conditional 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. TIA
Graph 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?test
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 ",".
