Here are some problems that our users have asked and received explanations on
I need a formula in Total Budgets F4 to go to the Data sheet, lookup the budget head (SPC) and then total for that quarter any income received. (Nominal code all 4000-4999)
Solved by O. C. in 26 mins
I need a formula to sort out rows as per source column data, for example,
Solved by M. W. in 29 mins
I have data in which column A has ID numbers and the other column have other data for example B has age, C has other information. The problem is that it is a large file composed of other files, see the example attached.
Solved by Z. Y. in 23 mins
Hello I wanted to know how to use data validation but to restrict the data for a letter. For example restrict the data in cell B4 to S or D
Solved by A. H. in 22 mins
I am struggling with multiple VLOOKUP. I have a name for example BSS.
In database I got as well name BSS but in multiple rows with different data in there. For example;
I have 12 different columns. Round number collection number date received etc..
Now I need to put this data like;
BSS (data returned) (data returned) (etc) (etc) (etc)
BSS (different data returned) (different data returned) (etc) (etc) etc)
I hope you guys understand where im going with this?