reduce

I have the following table in Excel: DATE VALUE 1/1/2024 100.00 2/1/2024 150.00 3/1/2024 200.00 4/1/2024 5/1/2024 6/1/2024 7/1/2024 8/1/2024 9/1/2024 10/1/2024 11/1/2024 12/1/2024 Lets say this table is called Table1. For the Months 4/1/2024 - 12/1/2024...

Using REDUCE function in Office 365 we can get combinations of items in different columns very easily. =REDUCE(A1:A4,B1:D1,LAMBDA(x,y,TOCOL(x&"-"&TOROW(OFFSET(y,,,99),1))))...

Hi guys! I have kind of a complex question. It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD). Much of this data is pretty useless to me, to be honest. But there are a few pieces of information that I want to extract (if the row...

I have created a very simple bar chart. The gap between bars is too wide and I want to reduce it. I am aware about using Format Data Series - Gap Width to reduce gap. However it also reduces the width of bars. Is there any option to reduce the gap between bars without altering their...

Hi I need a forumula for the following. In columns going left to right I've got dates populated, one day per column. On each of the Mondays (or Tuesday of the week, if that week had a Bank Holiday Monday!) there are target values showing that are the values that should be achieved at those...

I have two columns, on the first 1000 customer numbers and in the second an account number. About 500 customers have multiple account numbers. I want to reduce the lines. I want only one line per customer number and in column two a string of the corresponding account numbers delimited by the &...

=IF(DAY($B$1)=1|'Sheet2'!$C$6| IF(DAY($B$1)=2|AVERAGE('Sheet2'!$C$6|'Sheet2'!$C$13)| IF(DAY($B$1)=3|AVERAGE('Sheet2'!$C$6|'Sheet2'!$C$13|'Sheet2'!$C$20)| IF(DAY($B$1)=4|AVERAGE('Sheet2'!$C$6|'Sheet2'!$C$13|'Sheet2'!$C$20|'Sheet2'!$C$27)|...

Hi everyone! My file size is upto 29MB, although no data is entered yet. How can I reduce its size as there is no excessive programming or pictures in it.

Hello! I have in a cell a number which is the initial amount and in another cell a rate of decay. That rate can be a number by which you reduce the initial amount or a decay percentage by which again you reduce the initial amount. How can I write a formula that will calculate the decay of this...

Hi - besides eliminating data that is not longer in use and convert any formulas to values, remove links from other workbooks. Any major tips to reduce file size? Thanks,

Hopefully this makes sense, it doesn't sound possible to me. I have a number of columns E through to JG. Every 2nd column has a number (of people required) in rows 11 through to 72, some are blank on purpose. Every other column number is a price for that number of people. The number of people...

Hi All, I have been working on a workbook which contains around 150 worksheets to store monthly project reports. These are compiled using a number of UserForms and Dashboard entries. After making some additions (about 12 sheets) and some vba code changes I saved the file / wb and the file went...

I am trying to "Squeeze" my text left to right and not reduce the point value. This is for a tag to engrave spread sheet. My engraving software will condense the text left to right and not reduce the height of the text. I need my spread sheet to do the same so my customer can see how the...

I have four charts that I need to export to a pdf file which then runs on a monitor using Samsung MagicInfo (Only seems to work with PDF format) This is my VBA below but the issue I have is that the pdf then has a large border/margin around each graph, can I reduce these margins via vba? Sub...

Hi, New to the forum and hoping someone can help what is hopefully straightforward to those in the know!! I'm looking at getting a spreadsheet together to provide an overall percentage cost of a product that has variable pricing depending on the amount paid.... eg: upto £30000 charges 0.40%...

Hi Everyone, I need a macro that can look down column C and if any of the cells contain more than 30 characters reduce it by simple making it only 30 chrs long, So "abcdefghijklmnopqrstuvwxyz1234567890" would become "abcdefghijklmnopqrstuvwxyz1234" please help if you can thanks Tony

Hi, A colleague recently returned a workbook to me where she had added additional sheets, the file is now enormous 25MB. There is no code nor extensive logic, it is primarily SUMIF functions. I have worked through the sheets and cleared the contents of all unused cells, I have checked the...

I am working with two different workbooks, ive done both h look up v look up and a bunch of other formulas. my goal is to get certain info from one sheet to another sheet. in order to reduce the duplicate task of hand entry. firstly...column headers G5 and H5 are the same name....but i dont...

I have a 20-slice pie chart. How can reduce the saturation/intensity of the colors on the chart so that 1) they don't use as much toner, and 2) the black data labels inside the significant items are more legible.

Hi, I have a long list of data and occasionally I'll get a record that looks like this: AAA#03142-1143412140 I want to extract only "3142" What is the best way to cleanse my data set to reduce these to 4 digit records? Thank you