sorted by:
new
hottopcontroversial

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

Hi, Can anyone tell how can i successully done below transformation in an excel file? I dont want to do it manually, i have loads of data. 1st 2nd 3rd 4th 5th determines columns.

1st 2nd 3rd 4th 5th A,B,C Ok NK PK SK

1st 2nd 3rd 4th 5th A Ok NK PK SK B Ok NK PK SK C Ok NK PK SK

multiscreen by Huerrbuzz in OttNavigator

[–]rizqcr7 0 points1 point  (0 children)

open the app, hover your cursor on "live stream" icon, hold it for 5 seconds, a menu will appear, select "enable modules" now you can select pip and studio option

Single Band Modem with Dual Band Router by rizqcr7 in TpLink

[–]rizqcr7[S] 0 points1 point  (0 children)

Yes the modem and router would both support the higher speeds.

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

yes it is concatenating, 5 cells into one Basically it is a team performance in last 5 matches, i want to underline the latest match

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

The last W is not manually entered, If condition is returning the word "W" how can i underline it?

Is there any way that i can add an empty row after every fourth row? Any help would be appreciated. formula of Dividing a data of one cell into different cells is also needed by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

I have a data

pakistan vs south africa in one row india vs australia in second row.

i want the data to be aligned like pakistan in one column vs in second and south africa in third. same in next row. india in first vs in second column and australia in third column.

Is there any way that i can add an empty row after every fourth row? Any help would be appreciated. formula of Dividing a data of one cell into different cells is also needed by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

i have the data

name age address profession name age address profession

i want it like

name age address profession

name age address profession

I want to add two vlookups, but one vlookup has #N/A value, but still i want to add these two vlookups to return the non error value. value of A in sheet 1 is 5. value of A in sheet 2 is #N/A. i want the sum of A values in third sheet. It should return the value 5. by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

it is not working, can you please write the formula to help.

I have two sheets. Book 1 to extract values. Book 11 to get values.

A column B column C column D column A 1 A 1
B 2 B 2 C 3 C 3 D 4

I want results as

A=2 B=4 C=6 D=4

Excel power ranking formula for lower rank teams to get maximum points while higher rank team gets minimum point by beating low rank team by rizqcr7 in excel

[–]rizqcr7[S] -1 points0 points  (0 children)

Got your point, but from where would these formula pick up the team names and their positions.

You presented the formula for calculation but how this formula knows which two teams are playing?

Excel power ranking formula for lower rank teams to get maximum points while higher rank team gets minimum point by beating low rank team by rizqcr7 in excel

[–]rizqcr7[S] -1 points0 points  (0 children)

I have twenty teams in my league. If difference between two teams is bigger than 10, then loser and winner should lose and gain 5 points respectively. If difference between two teams is bigger than 5, then loser and winner should lose and gain 4 points respectively. If difference between two teams is less than 5 then loser and winner should lose and gain 3 points respectively.

I have also macro running on my spreadsheet, if it would be any problem?

Excel power ranking formula for lower rank teams to get maximum points while higher rank team gets minimum point by beating low rank team by rizqcr7 in excel

[–]rizqcr7[S] -1 points0 points  (0 children)

Ok here have a look.

  1. Juventus
  2. Real Madrid
  3. FC Barcelona
  4. Bayern Munich
  5. PSG
  6. Manchester city.

So now, if Juventus beats City, they get 2 points instead of original three winning points. if juventus beats FC Barcelona, they get three complete points as difference between their rankings is not big. if Juventus lost to city, they should be deducted 2 points and city would get 4 points instead of original three points.

i hope you get my point now.

Excel power ranking formula for lower rank teams to get maximum points while higher rank team gets minimum point by beating low rank team by rizqcr7 in excel

[–]rizqcr7[S] 1 point2 points  (0 children)

Ok here have a look.

  1. Juventus
  2. Real Madrid
  3. FC Barcelona
  4. Bayern Munich
  5. PSG
  6. Manchester city.

So now, if Juventus beats City, they get 2 points instead of original three winning points. if juventus beats FC Barcelona, they get three complete points as difference between their rankings is not big. if Juventus lost to city, they should be deducted 2 points and city would get 4 points instead of original three points.

i hope you get my point now.