How do you select the last 30 entries in a column of data to be used in calculations and graphs in excel?

Question

I have some data that's constantly being updated and would like to have some overall graphs and calculations as well as some last 30 entries calculations and graphs. How would I go about selecting these fields in excel?

Answer 1

Name the last 30 rows as a range. As items are added to the range, the range will adjust. Reference the data in your charts by the range name.

Answer 2

Could you have more specific with what you're trying to do?



As I understand your problem is that the range always changing.



For the overall:

When you're adding a graph to excel you should select a range for the graph, try to select full columns as the range, it's work?



For the last 30 entries:

Try to keep the these last entries at the top so their range don't get changed. you can do this by adding a "Added on" field to each row and sort it so the last added rows at the top.

Answer 3

plenty worse; at one time you ought to get 2 O tiers, be taught on the job, and then get a sturdy occupation / earnings. Now, the inflow of foreigners who will paintings cost effectively, skill you would be on the minimum salary for evermore. Plus, the upward push of folk with valueless tiers has additionally placed stress on the working type from above - wherein a level will become the minimum requirement for clerking etc. needless to say, there are a good number of different components that one must be right here all day - societies with plenty greater incidence of casual violence than Britain (traditionally) have rubbed off on us negatively whilst they arrive to stay right here. to call yet in simple terms another element. the standard loss of manners and appreciate for others is a important replace too.

Answer 4

Add a new column to yuor list (say X). I assume row 1 to be your headings. In your new column in row 2 cell type

=if(isblank(A2),"",row()) Copy down as far as is required.



Elsewhere on your spreadsheet type in cell

=index(A:A,max(X:X)-30). In cell below type

=index(A:A, max(X:X)-29) and so on till 30th cell type

=index(A:A,max(X:X)) Column A can be substituted for whatever column you need to get your info from. This will always retrieve the last 30 items of data from your list. Use these 30 cells as your basis for charts or formulas.