need answer

For example…… ( Please explain and give a solution step by step) Student ids (sheet 1-it has more column like this) Column 1. Column 2. Column 3 0000 Sunil. Maths 1111. Gayan. Science 2222. Ranjith. History 3333. Tharsh. ICT...

Hello, I have very simple data, that I want to group by SUM As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2. I started by summing like cumulative column, then divided the result by the limit and...

Goal: Need Folders to match names in Column C of Spreadsheet IF Folder Exists. Do nothing IF Folder Does Not Exist. Create IF Folder Name is not found in Column C, Move to different location Mighty Excel Masters please help, maybe you can tweak the code i have? It...

after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...

I have a worksheet with about 300 rows and 100 columns. I need to sum the rows based on one cell in the beginning of the row that contains text. I want to be able to type the text in a cell at top of the last column and use that as the reference to sum. Here is the formula that is not working...

Dear, i want to get total of value in each cell in every alternate row, like =sum(A5+A7+A9+A11+A13+...............A502.) how can i do it in short way. Regards